Ho do I find last cell in excel worksheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Linker IT Software said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Pointer and Cell 1
Last Modified By in a cell by user 3
Changing position of last used cell 4
Excel Error Help 1
Error message "cannot shift nonblank cells off the worksheet" 2
Unable to Insert Columns 5
Cannot Insert Column 1

Back
Top