2101:
autofiltering question and possible logic question
2102:
Macro to Create a new row if a column contains text
2103:
Copy data question
2104:
msgBox problem
2105:
Upgrading to excel 2007
2106:
Need to modify code
2107:
Excel Macro Prompting
2108:
Good references for programming with Excel/VBA
2109:
If Sheet Name, No Action
2110:
Help Writing A Macro in Excel
2111:
Help with text function
2112:
Tools - References
2113:
Macro Script
2114:
PLEASE CAN ANY BODY HELP
2115:
Suggetion for funtionality of this site
2116:
Removing named cells
2117:
Can Excel 2007 Templates Project run in Excel 2003
2118:
Workbook.activate acts dif when activewindow.caption changed
2119:
Check box driven order form
2120:
How do I update a template wizard form to Excel 2007?
2121:
Stock prices into excel
2122:
Populate multi-column list in worksheet not in a UserForm
2123:
Worbook.Activate Activates sht 1 even though this was'nt active sh
2124:
Excel list box or combo box - filled with data from SQL query
2125:
Lookup Macro
2126:
Sr Software Engineer/OLAP Product Architect
2127:
How do I concantenate two columns for the length of a table?
2128:
Looping Macro
2129:
Advice & Error Trapping
2130:
Please help...
2131:
Export a menu
2132:
Controlling Excel From Access
2133:
VB - With protected sheet
2134:
How to Remove Macro from SaveAs file
2135:
what's there in blank cell when data is exported to excel frm db
2136:
Help with simple 1-D motion simulation
2137:
Using Foxpro from within Excel
2138:
annoying subscript out of range error
2139:
=?windows-1252?Q?Run_a_subroutine_from_a_worksheet_without_button=2C_me?=
2140:
outlook from excel
2141:
Excel crashes when I open the file, except.....
2142:
if more than 2 decimal places
2143:
Sort an access database, remove duplicates
2144:
Work sheet hangs - help appreciated
2145:
Remove a row if data is bold
2146:
Remove last character from all data
2147:
Pop up in excel
2148:
conditional formatting a row
2149:
code to replace advanced auto filter
2150:
Branching in IE via XL Macro: pt I
2151:
Excel Crash in procedure.
2152:
macro for closing all Excel processes visible in TaskManager
2153:
Can excel service be used to show and save data in Database like SQL
2154:
Distinguishing what is causing close
2155:
How to read data from a spreadshet without opening it?
2156:
Auto import of data into excel
2157:
Simple looping question
2158:
Selecting header rows with macro.
2159:
Adam.. Where are you? You need to get back to the institution.
2160:
Loop Macro
2161:
Customizing the Ribbon UI with Office Open XML Formats Files
2162:
if iserror then value = zero problem
2163:
Range.Formula breaks Worksheetfunction.CountA
2164:
Copying a Row in a sheet based on criteria in another
2165:
What is the Correct Data Type?
2166:
Please help - Spin Button
2167:
Count Visible Cells when using Filters
2168:
Select File to Open
2169:
Code very slow
2170:
HOW TO EMAIL HYPERLINK OF ACTIVEWORKBOOK
2171:
Assign shortcut key to existing Excel Macro
2172:
I dont know whats wrong with this....
2173:
macro - small change
2174:
how do you skip empty cells or zeros when calculating the average
2175:
list box
2176:
how to hide "title-bar" in Excel?
2177:
Can this code be speeded up?
2178:
Sort Selected Cell References
2179:
Signing a Code that uses a Custom XLA file (Location problem)
2180:
Copy Non-Colored Cells to a New Sheet
2181:
Macros
2182:
HOW CAN I WRITE A CODE TO A COMMANDBUTTON CREATED PROGRAMMATICALLY
2183:
define a range that equals the first row of another range
2184:
is there a maximum amount of data that can be in a list?
2185:
.cells question
2186:
HOW TO CHECK FILE IS SAVED
2187:
String to Rounded Integer
2188:
QueryTable Supress Headers?
2189:
Copy/Paste Using 2000
2190:
How to clean a worksheet
2191:
Excel 2007 Crashes a LOT
2192:
VBProj.VBComponents
2193:
need advice on whether or not to use macro
2194:
What is compiling and should I do it?
2195:
Problems with Macros created in PC run in Mac
2196:
Getting around 255 Column limit
2197:
Opening file in VBA with Questions
2198:
Excel 2007 - Can Macros be added to the Quick Access Toolbar
2199:
application.volatile
2200:
Macro to find last row with Data, avg last 30, show result on row
2201:
If file exists then
2202:
Can you store a value in different levels of a multi array?
2203:
Warning Message
2204:
Create a help file into VBA
2205:
Selecting Till last row
2206:
borders in VBScript
2207:
Import Web Tables
2208:
Macro to control two workbook
2209:
unmerge with macro
2210:
Formatting autoshapes using built in excel formats
2211:
Lost Enable Automatic Refresh in Excel 2007
2212:
workbook open - microsoft solution - current user vs other users
2213:
=?windows-1252?Q?Last_Row=85=2E=2F_last_cell?=
2214:
Saving to a USB drive
2215:
Source Formatting
2216:
Extracting chart title from Embedded Excel Chart in PowerPoint
2217:
Extracting Excel.Chart title from Embedded Excel Chart in PowerPoi
2218:
Store code outside the workbook, is it possible?
2219:
How to size rows and columns in pixels rather than units
2220:
unprotect 1st sheet in every workbook in a folder and change month in
2221:
HOW TO EMAIL FILE LINK BY MACRO
2222:
Module / Sub as string
2223:
workbook error - please help
2224:
filter criteria
2225:
Prevent saving on specified location
2226:
automatic close of pages
2227:
Web Query
2228:
Variables to be use by different Sub
2229:
Little help please please!!!
2230:
automatically creating new xls pages
2231:
setting cell values in another worksheet?
2232:
Modeless form keeps taking 'focus'
2233:
Select a column from a matrix
2234:
query
2235:
Help with Resize
2236:
Picture Insert Security
2237:
subtotal worksheet based on criteria
2238:
macro to select match results
2239:
Macro Problem
2240:
Vlookup code problem
2241:
Special Char in footer ?
2242:
SUMPRODUCT question
2243:
Call Excel in VBA
2244:
Sendmail works one computer, not another
2245:
Error 28 out of stack space
2246:
Chart - Variable Series Collection
2247:
print preview do not update (?)
2248:
Check if cell value is between two numbers
2249:
excel not finding spaces in email addresses when searching
2250:
simple yet complex scenario - goal seek problem
2251:
Removing border around Check box
2252:
Prevent Errors When Using Links
2253:
Check if workbook is open...
2254:
Commandbutton captions
2255:
returning an array from a function
2256:
Moving within a form
2257:
Working with protected files...
2258:
Message when opening a sheet
2259:
Error - Need assistance Please - Object doesn't support this
2260:
Excel 2003 Finding External Workbook links using VBA
2261:
Trying to search an Array of Strings
2262:
Cell and Worksheet Location
2263:
Open Word Document using VBA in Excel
2264:
Programmatically adding checkbox and attaching event handlers
2265:
CUMULATIVE leaving 0
2266:
Excel VB - copying formatted dates programatically
2267:
Mail Merge
2268:
Copying worksheets between workbooks - The object invoked has
2269:
Text To Row Function
2270:
Vlookup help, please
2271:
Saving Changes to a Command Bar.
2272:
autoshape protection
2273:
fill a web form from excel vba
2274:
What is a 400 error? Why would I suddenly start getting it?
2275:
Inserting rows incrementally using a macros button
2276:
Is it possible to link the cell in excel to the size of the shape
2277:
Formula Required -
2278:
i've seen this before here yet the macro is hard to search
2279:
Clear Excel Clipboard with VBA
2280:
GetOpenFileName
2281:
copy cells
2282:
Size of filtered list
2283:
Code Fails Intermittently
2284:
Simple Question
2285:
active cell - get me back there
2286:
Colour functions on Chip's page
2287:
Changing default response of an alert through vba
2288:
Calculating number of days off
2289:
Accessing Embedded OLE chart information
2290:
Stack overflow exception, when chart is selected
2291:
Change UserName & Password from Worksheet,
2292:
Dynamic variable in formula ?
2293:
Open File *approved.xls
2294:
how to group time field in pivot table
2295:
CommandButton Enable not working in Excel 2007
2296:
ignore this post
2297:
3D Screen Saver causes error 380 with userform text box ControSour
2298:
UDF Naming
2299:
Does CDO mail require a reference?
2300:
How to add a combo box in a cell using the office web component 11
2301:
randomization in excel
2302:
help needed
2303:
calling xlfEvaluate/xlUDF in an xll
2304:
Using GetOpenFilename from a cell
2305:
How to reference a constant?
2306:
Efficient Nested Loop Solution
2307:
Efficient Nested Loop Solution
2308:
Msgbox in WorkBook_Open event
2309:
Write a Macro to retain rows based on certain criteria
2310:
chart cell references do not change when worksheet is copied
2311:
How to track object index in object collection
2312:
Isolating a row/column in a range
2313:
multiple user-defined functions in add-in (2007)
2314:
Copy worksheet without triggering events
2315:
Is there away to do this....?
2316:
How can I use a variable in a cell reference? Ex: $A$1:$F$"X"
2317:
Pivot macro problem
2318:
I need help sorting a table
2319:
Range Find
2320:
Array of Range Objects
2321:
Conditional Formating
2322:
Range, select, and printing arrays
2323:
Excel - Access Integration
2324:
Linking Files - copy a worksheet to a new workbook
2325:
linking files-update a cell in several workbooks
2326:
Clear borders macro not working in Excel 2007 but works fine in 20
2327:
Missing my macro book
2328:
Check whether a sheet is present in a workbook
2329:
Speeding up updating records using ADO
2330:
I'm getting crazy
2331:
close a file ater opening with GetOpenFileName
2332:
Use of Proper Case
2333:
Save records from one file into seperate other files.
2334:
VBA Converter for Excel 2007
2335:
Sending mail CDO from Excel 2007 on Vista
2336:
SUMPRODUCT with filter
2337:
Auto_Open, Expiry Date of VBA application.
2338:
zoom in on range
2339:
Turn off "Printing.." message
2340:
Frame
2341:
onCHange event
2342:
Change date formula to Value
2343:
sumif vs dsum
2344:
Can I save detail reports in different sort sequences?
2345:
SaveAs Copying Macro to New File
2346:
Sheet protected - user cannot interact
2347:
counting spercific charaters in selected cells
2348:
COUNTIFS function ?
2349:
Search Columns for Most Recent Date
2350:
Using Speach
2351:
Making two pie charts look alike
2352:
Do Event to stop concatenate Next statement running
2353:
how not to go on Loop
2354:
vba project properties via code
2355:
Network share problem
2356:
Divide Use column headings - Indirect?
2357:
Wscript and stored procedure
2358:
COUNTIFS function not supported in Excel 2003
2359:
Excel2000: Is it possible to run a pass-through query from Excel
2360:
Problems with Hlookup
2361:
Stripping characters from strings and writing contents to another
2362:
Question about Comments
2363:
Login
2364:
Cancel = True
2365:
conditional validation
2366:
number format change
2367:
VBA in Excel
2368:
Data entry help
2369:
Can't change the size of the plot area
2370:
Summary Page code help
2371:
Save worksheets to files automatically
2372:
create a global digital signature for free?
2373:
popup userform for b/days
2374:
getting error with empty listbox
2375:
digital signature
2376:
print preview in loop
2377:
Data not populating
2378:
Trying to get My Computer / Search results into a worksheet
2379:
Pivot Table, Subtotal, CalculatedItem
2380:
How do I do an Analysis of Means computation using Excel?
2381:
Position of Comment
2382:
Conditional Formatting
2383:
Create a animated logo
2384:
date entry in userform textbox
2385:
copy and paste
2386:
Format Conditions Formula1
2387:
Help with formula
2388:
Trouble cutting a range of cells
2389:
Parameter Pasing ?
2390:
Programming a chart object
2391:
GetSaveAsFilename Troubles
2392:
Stop Search ----> Ron de Bruin RDB_Filter_Data
2393:
Saving worksheets
2394:
failure in sheet with macro
2395:
After Save
2396:
Ultimate Control
2397:
Populate combo box, then hide rows that don't match chosen value
2398:
Data Validation and VBA
2399:
opening text file as a .xls file and not a .xlsx
2400:
How to perform SQL INSERT from vbs script
2401:
How to use ADOX on Excel? How to automate Excel invocation on existing xls file from vbs?
2402:
Formatting values in a form control. Is it possible?
2403:
Copy non blank cells from 1 sheet to multuiple sheets
2404:
Trapping blanks
2405:
How do I display all the filename in a folder in excel ?
2406:
File is corrupted after applying conditional formatting
2407:
hyperlink image for email
2408:
digital signature
2409:
userform popup with birthdays
2410:
Pivot Table, Calculated Field
2411:
empty listbox giving error
2412:
Get value of Option Button in Excel 2008 for Mac
2413:
Sum by month running balance
2414:
Add cc option to Send Mail + attachment
2415:
Data Validation - Propercase
2416:
Detecting an endless loop in the VB Editor
2417:
textbox validation with 3 conditions
2418:
move cursor to empty row ?
2419:
External Link to workbook
2420:
how to reference a changing 'last row' cell in a formula
2421:
How do I write a macro to increase the value of any cell by 1?
2422:
VBA SQL Statement not working
2423:
Find The Last Used Row
2424:
Ending a dll program
2425:
Find and FindNext
2426:
Create objet for InternetExplorer application
2427:
hi5
2428:
Format colum for number and next colum age
2429:
format colum for identity number and next colum age
2430:
Hyperlink to show a userform
2431:
mail merge
2432:
Cell Status Activates Macro
2433:
Goal Seek
2434:
Pass Arguments to CDO_Mail_Auto
2435:
Hiding macro-enabled password
2436:
BeforeClose event won't run when closing using macro
2437:
Extracting Web Data
2438:
code copy
2439:
Moving data from an array to a range when range consists of areas?
2440:
Controlling Microsoft Project from Excel
2441:
Expandable Rows
2442:
Print from PrintPreview macro method
2443:
Make Sheets VeryHidden With Code?
2444:
Combining two line of code
2445:
UDF: Roots of 1D Polynomials of Degree N and Real or Complex Coeff
2446:
display a calender that automatically shows today date
2447:
Macro to go to last row with values and average previous 30 values
2448:
How do I force a pivot column if there is no data?
2449:
Dropdown Lists and Funtions/Formulas
2450:
I can't get this to work