1:
Calendars 2:
question about ABS Function 3:
text box for displays of information in excel cells 4:
networkdays function 5:
How To: Use Cell("Format") to return MMMM YYYY instead of D3 6:
Determining a combo box by code 7:
In excel macros remove by default message's of excel 8:
tricky sorting question 9:
value interpretation 10:
Mileage tracking 11:
Sending Excel form to Exchange Folder 12:
Sumif based on 2 conditions 13:
How can I calculate the week number from a date, eg 21/06/05 = 26 14:
Moving total cell 15:
Counting items in one column based on another 16:
Count 17:
How to read Rows within a Column through ADO ... 18:
chart secondary axis crossing with x axis 19:
How time work with a file excel ? 20:
First days newbie 21:
Return mm/dd/yy based on 1st Day of Month 22:
Protecting sheet in a macro doesn't work 23:
=max(if(a2:a101=5.4,b2:b101))? 24:
Online Visual Basic Help? 25:
can an excel spreadsheet be set to remove all hyperlinks 26:
Collection as parameter 27:
Copying data to excel and deleting duplicates 28:
Moving Page Breaks in Page Break Preview 29:
I need a formula can you help? 30:
Proper SQL Syntax - DAO 31:
Finding Duplicate Values 32:
External Data 33:
Counter 34:
Email and if statements 35:
Formatting Data using a macro 36:
Old VBA code in MS office 2007? 37:
Excel Font - e-mail 38:
I may have found (yet another) bug in Excel 39:
Excel VBA to print a chart as a pdf file 40:
Need to extract hyperlink 41:
Import Excel Forms into Visual Basic? 42:
How do I keep the 0 at the beginning of my order? (098523) 43:
help with combo boxes and duplicate entrys 44:
Month/ year function. 45:
Re: DCOUNTA function not working right 46:
lock only formula cells without protecting sheet - leave open 47:
How do I copy information to the ascending by LName worksheet? 48:
bad file name 49:
Calculating time as a percentage 50:
How to count number of different cell formats 51:
Conditional formatting, pastevalues, clearcontents 52:
use of module level variables 53:
Custom commandbar (1 works, 1 doesn't) 54:
Sort sheet on sheet's Deactivate event 55:
Macro 56:
Save Macro w Suggested File Name to Network Drive 57:
Division on a sliding scale 58:
Cut & Paste Conditional Formatting 59:
Ctrl + V & Ctrl + S & Ctrl + X etc. etc. 60:
The Shifty Lie of a Query Table 61:
Enable CommandButton1 62:
Statistics 63:
Public/Procedure Variable 64:
Graph series collection 65:
Excel 2000, count, sort a list & count totals? 66:
Toggle Font Style Macro 67:
Lookup with 2 criteria 68:
Easy one for you pros! 69:
Vlookup to choose two fields 70:
Link into Word 71:
How do I get the column of a cell? 72:
scrolling a sheet with vb 73:
Set Print Area Macro 74:
userform? 75:
Generating random lists 76:
Calculating results when data changes 77:
Help with Excel 2002 78:
Macro Help - Loop Problems 79:
cannot select any cells to complete formula 80:
Assigned specific decimal space 81:
HTML Tags in Excel sheet 82:
Sumif referring to range names formulas not updating 83:
How do I get a date and time stamp automatically when entering dat 84:
Excel 85:
Menu Title code is where? 86:
A code to modify the system time ? 87:
Temporary Storage in IF function 88:
Another MS Query question 89:
problem when inserting or deleting cells 90:
How to filter out multiple occuring partnumbers? 91:
Creating a conditional screen based on multiple criteria 92:
code pasting a date changes date format in current month only 93:
numbers being entered show in formula bar but not in cell? 94:
Copy row/column size, print area...to other tabs 95:
Find string and format 54 columns to right 96:
Changing font size in row and column headers ? 97:
Defining a Moving Printing Range using Defined Cells 98:
Sumif - double column comparison 99:
spreadsheet calc 100:
Can you see what's wrong withthis code please.. 101:
Sorting a column from the last letter or 2 letters of a part numbe 102:
if, or 103:
Horizontal Scrolling 104:
Removing item from combobox with vba 105:
How do I Advancing to next column/cell in a Sheet.range(x)? 106:
Sumproduct Problem 107:
HOW TO CHANGE RANGE 108:
Use the .NET Library in VBA? 109:
Compile XLS sheet into EXE 110:
Date formula required 111:
Programming double click functionality 112:
Hiding functions in add-in 113:
How can I move several columns of words into one column in Excel? 114:
IRTDUpdateEvent failure 115:
Forms 116:
how to update functions in excel sheet? 117:
? To Tom Ogilvy or others on VBA Listbox 118:
When is it necessary to "calculate cells" - Relocated post 119:
Table lookup and more... 120:
Type mismatch? string 2 a long?? 121:
Pivot Table Ordering 122:
How do I see entire validation list without scrolling 123:
intranet + hyperlinks problem (open in new window?) 124:
Alignment problems 125:
MS Query Error Message 126:
How can I do this in one cell? 127:
More than 7 embeded if statements 128:
delete cells from one workbook to another 129:
Printer Selection 130:
Macros in a cell function 131:
Dependency of Excel on btrez.dll 132:
Path and Acrobat ActiveX 133:
Problems with permutation 134:
Validation List in other file 135:
Importing Macros into Excel 136:
find text in cell and replace it with part of the text in that ce. 137:
Testing an object varible for Nothing 138:
How do I use moving averages in Excel 2007? 139:
copy cell value problem 140:
Pasting every 8th line for example 141:
Not creating duplicating worksheets with the same name 142:
lock a total row below a list & allow inserting in the list? 143:
Wildcard character in an "If" statement? 144:
VBA to Rename Excel Worksheet Value of Cell. 145:
Disable Mouse During Macro 146:
dividing words in selected cells 147:
Making a copy using macros 148:
Formula Error 149:
Ranking Ties 150:
concatenate function 151:
Launching Excel From internet Explorer 152:
Conditional Formatting 153:
Data Filtering: 154:
Cell formating for Excel 97 155:
Unable to Loop Multiple Worksheets 156:
subtotal issues with NULL cells 157:
Load Testing Tool required for Excel Pivot table based OLAP Application 158:
Using COUNTIF for Counting Words? 159:
Auto Fill Defaults 160:
cell fill color 161:
Is there a Way to Find the Cell Row and Column From my UDF 162:
lastcell 163:
Excel 2007 problem 164:
Calling Public Variables between diff Modules 165:
decimal point override does not work 166:
How to view the code for excel built-in functions? 167:
Buying Digital Signature to Bypass Security in Excel 168:
Shared file issues 169:
Determined to eliminate .select 170:
Displaying Drop-Down Menu Options 171:
Too tricky? 172:
Number of items meeting a > criterion 173:
Differences between 'trend line' and 'correlation'? 174:
Excel cell format 175:
HELP - UDF recalculation upon opening workbook 176:
How to pull in 2 different rows and compare them 177:
Drop Shadow Problem 178:
Replacing a value in the string variable 179:
empty 180:
Conditional formatting 181:
Help please 182:
VB Efficiency: Inserting a Row 183:
Value or function as result.... 184:
Spreadsheet component in an ActiveX dll 185:
Mimic Print Preview? 186:
how to seperate into columns? 187:
Active Cell / Data Validation question 188:
Create Comments 189:
how to create a tabe in excel 190:
Selecting the Second largest number 191:
Count number of textboxes 192:
Can you query a graph? 193:
vba function 194:
Printing problem 195:
EXCEL WORKSHEETS - FORMATTING ISSUES 196:
Date macro 197:
When does the Access query run at worksheet open? 198:
Names of Worksheets in a file 199:
Multiple Criteria and Adding them together 200:
Excel "Move or Copy" and "Delete" sheet functions 201:
Assigning add-in function to custom button 202:
disable get pivot table function 203:
UPDATE : Phantom VBA Projects (again) 204:
Error in VBA Coding in Macro 205:
How can I map templates? 206:
I want the greater number of 2 cells to show in a separate cell 207:
Can I build a sentance from data tables in Excel? 208:
Macro's scip Files!!! 209:
How do I show formulas (in values) for the calculation? 210:
IF ISNA HELP, please..I cant add #N/A but 0 is another story 211:
Why can't I embed a picture in an Excel Worksheet CELL? 212:
automating market updates 213:
Text selection macro problem 214:
odd question 215:
SUBTOTALIF function 216:
SUMIF((U:U,"ITEM#")AND(A:A,>4/01/06 AND <6/31/06),V:V) 217:
timestamp comments 218:
I have a problem with getting a total Sum of numbers (URGENT) 219:
multiple results search 220:
Pivot: Calculated Field vs Calculated Item 221:
make macro "invisible" to end-users? 222:
Dynamic Ranges/Cells?? 223:
Userforms Values to Workbook Cells 224:
I have a problem with "Unlaod Me" 225:
Checkbox to remove recipient from email 226:
problem with a pivot table 227:
Cut and paste causes Excel to hang 228:
Paste Special - Skip Blanks 229:
Copying text from a free form field 230:
EMBEDing an object to access procedures such as MouseMove 231:
Fitting second series to known curve 232:
Accelerator Keys 233:
COUNTIF criteria 234:
How do I? Link Row Headings 235:
Subscript Out Of Range Error? 236:
DSN Connection with OpenRecorset 237:
Determining if data is sorted in descending order 238:
Accessing rows after AutoFilter 239:
I want to select a row and insert a copy later in the worksheet 240:
HELP, dont know how to describe this in a subject line 241:
Can I open a graphics file from within Excel 242:
open 2 files of different signature 243:
Identify number of numeric sets in a long string of numbers 244:
WorksheetFunction.Sumproduct(syntax... 245:
MAC authentication in Excel VBA 246:
Externalizing formulas. 247:
Dynamic cells referencing 248:
Cut and Paste entire row from one worksheet to another 249:
Compile VBA code 250:
Excel OCX/ActiveX Visual Controls for creating a Excel Dashboard/Scorecard 251:
Error in entering a formula 252:
Non-header or footer page numbers 253:
How to fill in zero. 254:
changing axis number 255:
Help with vbModeless 256:
Excel subtotals cells with a formula - HELP 257:
Re-Post: Before_Print Sub Doesn't Trigger 258:
comparing 2 columns of numbers 259:
evalaute concatenation gives problems 260:
random numbers 261:
Adding a total row to a chart data table 262:
How do i drag formulas down 263:
how do I make a template to lock some information and also allow . 264:
Show Macro list (tools->macro->macros) 265:
Built In Support for Sorting Objects 266:
Code to replace Advanced Filter 267:
Zero in front of number 268:
How do I enter variable data into a formula 269:
Excel addin problem 270:
Does Size Matter? 271:
Replacing all references to a file, with a new file name. Lots!! 272:
Toolbar Button Coordinates 273:
DIR function and compressed folders 274:
Quick question on Error Trapping 275:
How to insert date last saved into the sheet (not the footer) 276:
how do i use contains in an if statement 277:
Disable MACRO 278:
Moving info in a cell 279:
how to auto copy excel cells to outlook email 280:
Populating Multiple Worksheets with one entry 281:
Macro to delete duplicate data 282:
Populating a database from a questionaire 283:
Automatically add Conditional formatting on data/subtotals 284:
SOS: Excel custom Toolbar 285:
preventing excel from launching a new browser for each hyperlink 286:
Passing the Name of a Control Between Macros 287:
=IIF(h2 = WholeNumber, "XX","YY")? 288:
Break all links in the workbook 289:
Pivot table field list sorting 290:
vb code - automatic transfer of data from one sheet to another 291:
How can I alter this Macro? 292:
VLookup & Nested Functions 293:
Looking for a Black-Scholes Employee Stock Option valuatiion mode. 294:
changing function keys in windows xp 295:
PIVOT TABLES-PERCENT/AMOUNT OF CHANGE 296:
Working within a workbook without activating it? 297:
Timestamp in log 298:
Calculations not working on pasted values from Access 299:
turn off auto subtotal 300:
runtime error 91 by passing a value between modules 301:
consolidation of tables in excel with text and figures