Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Last Cell
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. |
#2
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Last Cell
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) "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. |
#3
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Last Cell
Hi Bill,
Take a look here. http://www.contextures.com/xlfaqApp.html#Unused HTH Martin "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. |
#4
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Last Cell
Using UsedRange resets this.
Dim rngUsed As Excel.Range = sh.UsedRange Thanks all for quick responses. "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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing Options | Excel Discussion (Misc queries) | |||
Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing | Excel Discussion (Misc queries) | |||
Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 | Excel Worksheet Functions | |||
NEED VBA TO SELECT A CELL; NOTE THE CELL VALUE;COPYADJ CELL;FIND CELL VALUE IN A RANGE AND SO ON | Excel Programming | |||
How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) |