Last Cell

[Allison]

Is there a way to change the which cell Excel tracks as
the last cell? Thanks!

 

[Frank Kabel]

Hi
not quite sure what you'e looking for?. If you have to re-set the used
range try
http://www.contextures.com/xlfaqApp.html#Unused

 

[Allison]

-----Original Message-----
Hi
not quite sure what you'e looking for?. If you have to re- set the used
range try
http://www.contextures.com/xlfaqApp.html#Unused

--
Regards
Frank Kabel
Frankfurt, Germany



.
Frank: Thanks for your quick responses to my

questions....When you depress Ctrl + End, you move to the
intersection of the last active column or row. If you
have used a cell beyond that location, and have cleared
the contents, depressing ctrl + end still takes you to
that cell that was once used. You can also used the Edit
Go To command to take you to the Last Cell (under
Special), but again if you have used a cell, but then
cleared it, you still go to that previously used cell.
Does that help? That is what I mean...Thanks....Allison

 

[DDM]

Allison, take a look at this page from David McRitchie's Excel pages:
http://www.mvps.org/dmcritchie/excel/lastcell.htm

DDM
"DDM's Microsfot Office Tips and Tricks"
www.ddmcomputing.com

 

[Bob Phillips]

Hi Allison,

Go into the VBE (Alt-F11), and enter this in the Immediate window and hit
Enter

activesheet.usedrange

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)