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:


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).


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

Thanks mightily old chap/(ess) (nm)