And sometimes hitting ctrl-end or using Leo's code will go further down or to
the right than you expected.

You can try to reset the last cell by using techniques at Debra Dalgleish's
site:
http://www.contextures.com/xlfaqApp.html#Unused



Elsie wrote:

Thanks.... but just curious.... how do I select the last cell?

Elsie

"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message
...
ActiveSheet.PageSetup.PrintArea = ActiveSheet.UsedRange.Address

--

Vasant


"Elsie" wrote in message
...
Hi, how do I select the last cell of all my data in a worksheet?
something
equivalent to when you press ctrl+end..

I want to select the last cell to the home cell and set these as the
print
area....


Elsie





--

Dave Peterson