In the addin litLIB I have created a function LastRow that you can use.
Example: =LastRow(2)

This function will display the row number of the last populated cell in
column 2 (B). Equally there is a FirstRow function, a FirstColumn and
LastColumn function.

If you like to have a look at litLIB please browse to
www.oraxcel.com/projects/litlib

Gerrit-Jan Linker
Linker IT Software
www.oraxcel.com
Author or litLIB: www.oraxcel.com/projects/litlib

"Harj" schreef in bericht
...
Hello,

I have tried using CTRL+End which goes to last populated cell.... most of
the time!! But if some cells are cleared and last populated cell is before
"previously" populated cell the above comman still goes to that location!

How can I reset it??