1:
Macro to compare two list 2:
Float a window over sheet 3:
My ChDir Statement doesn't work 4:
Work around Calculated Field limitation 5:
VBA to proctect locked cells in sheet 6:
Can I Atomatically Split Cell Contents 7:
Array / Looping Question 8:
Names of Shapes 9:
Dynamic Values in Procedure 10:
copy and paste formulas between deferent workbooks. 11:
Evaluate vba matric 12:
Need some syntax help, please 13:
stop code execution 14:
Add-In macro execution problem 15:
How to convert to absolute references including the sheetname? 16:
excel userform save problem 17:
Changing Cell Color with macro 18:
Pivot Table Query 19:
Macro to Paste Special Row Heights 20:
automated spreadsheet 21:
Refedit (can't get to work at all) 22:
Loop thru All Files in a Folder 23:
Populating a listbox with values from a sheet. 24:
Worksheets - Add / Move between 25:
Format of a textbox on a user form controled by a spinner 26:
Compile error macro is 111K. how do I fix macro 27:
Open Access from Excel 28:
Macro and Pivot Table 29:
migrating VB modules into Office 2003 30:
What is the formula to convert a whole column of date to text? 31:
Macro to print several worksheets does not work! 32:
Saving file to *.prn format 33:
Setting the Send to Value xlDialogSendMail 34:
UNIQ EXPEREINCE: PROCEDURE WORKS FINE USING F8 BUT GET ERROR WHEN COMMAND BUTTON IS CLICKED 35:
Sorting related numbers into defined groups for averaging 36:
List an object? 37:
sorry...I'm a terrible idiot and still can't do anything...:-((( 38:
removing hard coding from code 39:
Error in Code - Pasting Values 40:
Removing invalid characters from proposed sheet name 41:
How to refresh sheet while UserForm is open 42:
Retrieving Names of Worksheets 43:
Hide Column Headers but not row (Headers) 44:
create named range specific to worksheet 45:
PROBLEM : Excel automatically updates the macro locations in the toolbar 46:
Function to display username/networkname 47:
[Q] msoShapeRectangle: variable not defined 48:
Office xp 49:
Change color of Autoshape in chart 50:
Workbook crashes after renaming a worksheet - References problem? 51:
Find the nearest point to 1000 rows where "amounts" balance and apply special formatting to that row 52:
Copy column A and column D from all sheets into new worksheet 53:
copy / paste 54:
cell splitting 55:
No refresh in target cell when using worksheet.cells.formula = 56:
Excel, how do I write a macro to convert the date value to text? 57:
pausing vba for refresh 58:
R1C1 Error with Merged Cells 59:
get the value of a formula in cell B1 into cell A1 without changin 60:
Find last value in range 61:
Formula to capture Document Properties 62:
Split Cells? 63:
Detect which shape was clicked? 64:
How to print a page of a multipage userform 65:
Macro syntax: SaveAs Filename=ActiveCell.Text . BUT to a specified folder 66:
VBA code for different versions of Excel 67:
updating of worksheet against info from another worksheet 68:
Where does the knowledge come from? 69:
union range problem 70:
Wait for refresh/calc before proceeding 71:
How do I create a new Menu in Excel 72:
Flex grid microsoft 73:
Macro: Prompt user for xls file to add chart 74:
Displaying relevant info according to output 75:
created form, want to require input 76:
First textbox in form not accepting input properly 77:
excel functions and User defined functions 78:
Add validation using sheet code 79:
is application open? 80:
work roster setup 81:
Easy code!!!! 82:
Loop with two workbooks 83:
password change again 84:
Run-time error '424' in VBA event handler on XL shutdown 85:
folderexists code no longer works after moving to excel 2003 86:
writing a Function with a variable number of arguments 87:
Deleting lines with a variable. 88:
Assign Macros to a dropdown list 89:
Counting and Summing with VBA 90:
Do While only does once 91:
Printing Excel from an ASP page 92:
Getting reference of an excel cell from other sheet 93:
"Show Placeholders" in options/view menu does'nt work. 94:
How can I allow only cell contents to be copied but not formatting 95:
Changing the format of a cell after a time limit 96:
distinguishing filenames 97:
read sheetnames with ADO 98:
Concatenate UDF help please 99:
Vba goal seek 100:
Problem finding pagebreaks 101:
problem with an iif() function in a formula 102:
Excel crashes with createEventProc for a button 103:
Pivot Tables Formatting interior color &Type Mismatch 104:
Where is the autosave function in Excel 2003? 105:
summing a range in a closed file 106:
Sendkeys to run Find 107:
Formula from VBA to Excel worksheet 108:
Sorting data and retaining additional information with value, not 109:
Cannot sane all data and formats 110:
detecting shape clicked on 111:
Forms, Bound Columns etc 112:
Insert Row Specified Sheet 113:
Ribbon events??? 114:
Display error? 115:
Format statement no longer throws an error 116:
Call Names 117:
"Comment" in an "Oval" ? 118:
Attach all Open Workbooks to email as separate files? 119:
Combo box control Drop down list moving 120:
user form export 121:
VBA Code for selecting days 122:
Dropdown control as multiline 123:
Loop every 26 rows and if.. 124:
Last day of month is saturday or sunday? 125:
Need help with VBA Macro 126:
If statement in Auto_Open 127:
Control Box Option Buttons 128:
How to program keystrokes other than CTRL+something? 129:
Yes, if copy paste for the user doesn't become killed .... 130:
Pre-checking checkboxes in a dialog box 131:
Re-Alphabetize list with hidden rows 132:
Do while empty colomn 133:
Pivottable Pivotselect string 134:
Define Page Setup for whole workbook 135:
Best Place to Learn VBA 136:
Autodate worksheet problem 137:
VBA to read "form" 138:
Opening a Database from Excel 139:
Importing/querying data from .mdb file into Excel 140:
VBA code to make a progress tool bar work 141:
Help with Combo Box code 142:
Query Refresh without filename prompt 143:
how to tell which hyperlink was clicked 144:
Restore Macro Speed 145:
How do I convert decimals to fractional odds for horse racing? 146:
the first event that occurs after a file is done saving? 147:
For Tom Ogilve re File check 148:
Setting Custom Icons at Run-time 149:
Thanks, Tom. Creating buttons using VBA 150:
OLEAUT32.dll 151:
Page Size 152:
Accessing multiple workbooks through a macro 153:
Assign Sub to Custom Button 154:
Importing a txt file to a ComboBox itens 155:
"Asin" doesn't work in VB for Excel macros 156:
Heading for Report from UserForm. 157:
How to "visit" other forms properly? 158:
BeforeSave event problem 159:
Macro to select a row that has max value and paste it in an empty row 160:
Anybody remember Excel4Macro's 161:
huge problem!!! 162:
Application FaceID? 163:
SelfClosingMsgBox 164:
VBA dynamically format Row1 165:
merged cells and wrapping text 166:
How to conditionally sum values depending on values in other colums 167:
countbycolor counts all cells in a merged cell 168:
Dates in TextBoxes 169:
grapic chararcters in a userform 170:
VBA macro generating MD5 171:
to previous location 172:
Tim - perfect - thanks (eom) 173:
selecting current row information and transfering it. 174:
Dynamic chart to track progress by date 175:
Loop with Cell Change Event 176:
Incrementing a field 177:
CopyFromRecordset Question 178:
Startup Path 179:
do xl add-ins have worksheets? 180:
check variable(text) with cell (text), textbox 181:
Wild Card!!!??? 182:
Button - Macro to auto-populate data 183:
Workbook_Open - Multiple Events not all working 184:
Condensing Data onto a New Worksheet 185:
Declaring a Range Object 186:
Importing Access record into Excel using MSQUERY question 187:
Solver and Excel 2003 188:
Couple of basic questions from a beginner: 189:
copying by formula.... 190:
Getting Application.Sum to act like =SUM 191:
SAVE AS menu option 192:
Images will not display 193:
Referenced Workbooks 194:
"file not found" error message when launching source file 195:
FileCopy (now OK!) 196:
Publicising Benefits of VBA 197:
Getting an exact match 198:
Access Automation to Excel 199:
Current file name in ConsolidationReference FileName 200:
Running code before saving workbook 201:
Help - Search for set dates then average other cells values 202:
Time in combo boxes change to decimals when printing 203:
Macros in a template run from Custom Toolbar attaching to wrong file. 204:
copy columns based on value in a particular row 205:
How to exclude a list of number from another list? 206:
worksheet embeded ? 207:
Do I Need Licence to Develop Excel Tools for Sale? 208:
Disabling the option to move cells programatically 209:
Protect ALL cells If Q 210:
Web Queries Truncated 211:
Need help speeding this up 212:
save as latest excel format 213:
Ideas for "linking" rows for printing. 214:
Bizarre macro problem 215:
Disgarding lnk files 216:
VBA: rename a variable 217:
Combined VBA line syntax 218:
Populate Combo Box With Filtered List 219:
ERIT: how to subtract whole #s but not fractions.. 220:
Newby Needs minor tweak on this VBA Macro code for Excel 221:
AutoText for VBE? 222:
How do I program telnet using exel through dos? 223:
Difficult planning 224:
to open a pdf file from a macro in excel 225:
Envoke code with button rather than as data is entered. 226:
Help within user defined function 227:
Create a Pop up box that prompts for criteria in a macro 228:
Accessing value in a range using Automation in a C# DLL 229:
Excell's options 230:
Using a macro to import from another spreadsheet 231:
Files 232:
VBA Update Sheet Where... 233:
Automating application error responses 234:
Start up folder v Addin folder 235:
Message prompt in VBA 236:
Customise Button on toolbar 237:
How to copy to cashe? 238:
Compare two lists for matches 239:
Search Modules for Cell Addresses in Range Variables 240:
Range for a single cell 241:
Worksheet_Change fires even when no change? 242:
sending only one sheet from a workbook 243:
'combine' question 244:
Combo Box Properties 245:
macro stops copying sheets into a book after the 11th sheet 246:
complicated... not for the faint hearted 247:
Showing activecell in view 248:
Alias for a Pivot Table Column 249:
Procedure not running automatically... 250:
Still retuns to begining of range, Please Help 251:
Excel sheets saved as XML files that can be read by .NET 252:
Prevent Excel crash when running 253:
Printing, VBA 254:
My Add-in causes problem with opening a file twice 255:
Return the name of a range 256:
Change the color of a cell based on a calculated value 257:
Test for VBAProject Locked from Viewing 258:
Update links and SaveAs? 259:
get subtotals results as a variable 260:
Hide Toolbar with vb 261:
Newbie Q - outlook & Excel 262:
A problem when use create excel file using Microsoft excel ODB 263:
'For - Next' question 264:
Copy text with more than 65,536 lines into Excel 265:
for Tom Ogilvy Please 266:
Format all new text 267:
Programmed error messages 268:
OfficeXP "Cannot open pivot table source file" when refreshing pivot table 269:
How to Save Custom Icons? 270:
Excel VBA - Get data from 2nd workbook 271:
Automating the downloading of web page and sending it via email 272:
enter value line by line 273:
Removing all Toolbars in one line 274:
create column & Row in userfrom 275:
Enable Word Template Macro from Excel 276:
Changing the cursor 277:
Code to add comment box 278:
take text from form textbox and put in cell... 279:
can you encrypt an excel cell 280:
Input box not working with IF statement 281:
Select the last Cell of a selected Cellarea 282:
Multiple Monitor Work Stations on a Network 283:
How can I hide zero rows in a pivot table with calculated items? 284:
Print button help 285:
SaveAs problems 286:
Conditional Formatting, Multiple Values 287:
Find/replace [Zx] with [Znumber] 288:
John Walkenbach Colour Palette 289:
Scroll bar protection 290:
Concantenated SUM() problem 291:
Create a New Random Number Every 2 Seconds 292:
Using Outlook *.pab in Excel 293:
copy, paste and save file 294:
How to execute a CommandButton_Click macro without clicking on 295:
Disabling menus etc 296:
Restricting Access to VB Code (xl98) 297:
Print enveloppes' address from Excel 298:
Auto Updating of Progress Reports... 299:
GetOpenFilename - dialogue box 300:
Can Macro command to open files? 301:
basic file I/O