MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Find last used cell in column


Posted by Barry ward on August 07, 2001 4:12 AM

I want to select a range where the first cell is fixed but the last cell changes according to the data


Posted by Aladin Akyurek on August 07, 2001 5:46 AM

If the first cell is A1 and your data type in column A is numeric, you can use:

=ADDRESS(MATCH(1E+30,A:A),COLUMN(A1))

This will give the address of the last cell in use.

Note. You can replace COLUMN(A1) with the hard-coded column number (that is, 1 for column A).

Aladin

Posted by Barry Ward on August 07, 2001 6:35 AM

Thanks mightily old chap/(ess) (nm)