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??

If CTRL-End takes you to cell E15 but cells were cleared and the lower
right corner of your data is now at E12, delete rows 13 - 15 and save
the spreadsheet. CTRL-End will then take you to E12.

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??

Thanks dave, I was trying to refresh the last populated cell without saving
the file. Excel refreshes this informaton when file is saved; even without
deleting any rows! I have found that if you open MS script editor it forces
excel to refresh the background info and last popu. cell info is also updated.
Regards

"Dave O" wrote:

If CTRL-End takes you to cell E15 but cells were cleared and the lower
right corner of your data is now at E12, delete rows 13 - 15 and save
the spreadsheet. CTRL-End will then take you to E12.

Thanks

"Linker IT Software" wrote:

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??