Visit Debra Dalgleish's site for some techniques for resetting that
lastusedcell.
http://www.contextures.com/xlfaqApp.html#Unused

Jeanne wrote:

Control end takes you to the end of the spreadsheet. My problem is if I have
eliminated rows in the spreadsheet and then do control end it takes you to
the end of the document that was originally there. I only want it to go to
the new end of document. I work with large files and can eliminate pages of
data. Is there anyway to accomplish this?

--

Dave Peterson