Last Cell

  • Thread starter Thread starter Allison
  • Start date Start date
A

Allison

Is there a way to change the which cell Excel tracks as
the last cell? Thanks!
 
-----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
Click to expand...
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
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed 0
Last Modified By in a cell by user 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel VBA setting Ranges 2
Excel Macro to automatically go to the right of the last colored cell 0
Excel VBA 1
Tracking Changes Column Limit 2
Changing position of last used cell 4

Back
Top