Last Cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bill - 20 Mar 2008 12:54 GMT

To All

I was wondering if you could help me with my problem.

If you have data in your worksheet and you say delete all the data in the
last row, when you say F5 (Goto) "Special" and select "Last Cell" then it
will always go to the data row that you have just deleted. There seems no
way to get the "Last Cell" to update to where the last data is. Does anyone
know to resolve this issue please.

Thanks in advance.

Reply to this Message

Ron Coderre - 20 Mar 2008 13:03 GMT

Deleting the data won't impact the "Last Cell". The "Last Cell" doesn't
refer to the current data. It refers to the last cell that ever had any
activity (including cell formatting, but not entire row/column formatting).

You'll need to:
. Delete the extra rows and columns
. Save the workbook

Depending on your version of Excel..
. Close/re-open the workbook

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

> To All
>
[quoted text clipped - 7 lines]
>
> Thanks in advance.

Reply to this Message

MartinW - 20 Mar 2008 13:05 GMT

Hi Bill,

Take a look here.
http://www.contextures.com/xlfaqApp.html#Unused

HTH
Martin

> To All
>
[quoted text clipped - 7 lines]
>
> Thanks in advance.

Reply to this Message

Sandy Mann - 20 Mar 2008 13:09 GMT

Save and close the workbook and open it up again and try again - the last
cell should have been reset.

Signature

HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk

> To All
>
[quoted text clipped - 7 lines]
>
> Thanks in advance.

Reply to this Message

Bill - 20 Mar 2008 13:26 GMT

Using UsedRange resets this.

Dim rngUsed As Excel.Range = sh.UsedRange

Thanks all for quick responses.

> To All
>
[quoted text clipped - 7 lines]
>
> Thanks in advance.

Reply to this Message

Rate this thread: