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



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Gary Brown" wrote in message ...
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


"dp" wrote:

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

"dp" wrote:

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