Thread
:
Last Cell
View Single Post
#
4
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
Sandy Mann
external usenet poster
Posts: 2,345
Last Cell
Save and close the workbook and open it up again and try again - the last
cell should have been reset.
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"Bill" wrote in message
...
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 With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann