last row

[TJG]

Hi,
Is there a function that will tell me the last not null
cell in a worksheet regardless of the column.

Thanks for any help

 

[Tom Ogilvy]

=MAX((A2:Z500<>"")*(ROW(A2:Z500)))

placed in row 1 and enter with Ctrl+Shift+Enter rather than just enter since
it is an array formula. the more cells you include in the formula, the
slower your sheet will calculate, so I would only examine a feasible
reagion.

You will get a circular reference error if you include the cell with the
formula in the range.