Trouble with dynamic named range21989 (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-10113106 (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?23129 (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
B4-A1.
A1 B1
1
2
3
4
5
6
xx ...

Need largest number62173 (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?01809 (6/7/2010 9:25:50 PM) Donoops. 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...

Sort Routine Macro for Excel Worksheet12007 (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 fire33169 (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 printing12078 (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
with...