Trouble with dynamic named range21941 (6/7/2010 5:34:35 PM) UtfIn 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)
Deleting Duplicate Rows 06-07-10113076 (6/7/2010 8:06:22 PM) UtfHi,
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...
How to do this with macro?23100 (6/7/2010 4:59:05 PM) ArtoI 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
Need largest number62150 (6/7/2010 5:03:28 PM) UtfI 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...
Re: How to do this with macro?01785 (6/7/2010 9:25:50 PM) Donoops. to find the last number in b and subtract a1
Microsoft MVP Excel
"Don Guillett" wr...
Sort Routine Macro for Excel Worksheet11985 (6/7/2010 5:31:30 PM) JCOI 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...
Change event does not fire33117 (6/7/2010 6:06:11 PM) UtfHello!
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...
Save data before printing12056 (6/7/2010 6:43:44 PM) SagaHello 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