Richard, have a look here also

http://www.mvps.org/dmcritchie/excel/lastcell.htm

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **
"RichardG" wrote in message
om...
Greetings All,

When a sheet has been cleared of all of its text, using the
keystrokes, CTRL+SHIFT+END, still performs the action of extending to
the last used cell. How does one reset this action and thereby no
action is performed in trying to go to the last so-called used cell?

Many thanks.

RichardG