Trouble with dynamic named range 2 477 (6/7/2010 5:34:35 PM)
In an Excel 2010 workbook I created a dynamic named range from the Formula tab using the Define Name utility. The formula I entered is: =OFFSET(Price Groups!$AP$2,0,0,COUNTA(Price Groups!$AP:$AP)-1,1) ...
Utf

Deleting Duplicate Rows 11 628 (6/7/2010 8:06:22 PM)
Hi, I checked out the archives for close to an hour, but I couldn't figure out how to change the codes given there to suit my needs. I have a large set of data, from about A1 to X441. In column X, there ar...
Utf

How to do this with macro? 2 405 (6/7/2010 4:59:05 PM)
I have several cells in one column, what include numbers (example B2-B4). After few empty cells, I have a cell (example B7), what include formula B4-A1. A1 B1 1 2 3 4 5 6 xx ...
Arto

Need largest number 6 373 (6/7/2010 5:03:28 PM)
I have a file in Excel 2003. In 1 column I have a numeric field. In the next column I have a 2 digit apha field. In the third column I have another numeric field. For each row I need a formula in the 4t...
Utf

Re: How to do this with macro? 0 467 (6/7/2010 9:25:50 PM)
oops. to find the last number in b and subtract a1 =INDEX(B:B,MATCH(9999999,B:B))-A1 -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett@gmail.com "Don Guillett" wr...
Don

Sort Routine Macro for Excel Worksheet 1 550 (6/7/2010 5:31:30 PM)
I have an excel that requires a sort routine. I tried using the start/stop recording. The code is shown below, however, I need this routine to work when you don't know how many rows are in the data. My m...
JCO

Change event does not fire 3 806 (6/7/2010 6:06:11 PM)
Hello! I have a worksheet with checkboxes. Each checkbox is linked to a cell. When checkboxes are checked/unchecked the cell changes, but the Change event for the sheet does NOT fire! Is that how it is sup...
Utf

Save data before printing 1 482 (6/7/2010 6:43:44 PM)
Hello all, An acquiantence is programming in Excel 2003 and has a sheet where theuser enters receipt data. When he is done, he clicks a boton to copythe data from the sheet to another in tabular form with...
Saga