enter in A1 or any other cell......... =SUMPRODUCT(MAX(($A$2:$A100000<>"")*(ROW($A$2:$A100000)))) to give you the row number of the last cell with a number. Found this one in a google search. Assumption: not more than 100,000 rows.

regards
Bill K New Zealand