Last cell in worksheet

[dp]

I only wanted the first 66 rows of a file, so I highlighted and deleted rows
67 - 126. If I use ctr-end (or go-to last cell) it takes me to R126. How
can i find out what is in that cell?
Excel 2003, Windows Prof 2000

thanks
dp

 

[dp]

After I logged on here and posted, I returned to this file and now I get the
correct last cell. Did it just take 5 minutes or so for the changes to
register?

Still trying to catch on!
dp

 

[Gary Brown]

When you save your workbook, the last cell is refreshed from row 126 to row 66.
--
Hope this helps.
If this post was helpfull, please remember to click on the ''''YES''''
button at the bottom of the screen.
Thanks,
Gary Brown

 

[Ron de Bruin]

When you save your workbook, the last cell is refreshed from row 126 to row 66.

Not in every version, sometimes you must close/reopen the file

See also this page if you want to use code
http://www.rondebruin.nl/last.htm

 

[RagDyer]

I believe the necessity for that action Ron, goes way back to XL97, or *PRE*
XL97!