View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
[email protected] EagleOne@discussions.microsoft.com is offline
external usenet poster
 
Posts: 391
Default Ensure Excel goes to last used cell upon startup

Everything else being equal, Excel should open very close to the last screen-view on that sheet
prior to final save unless an event macro is working behind the scenes or if you hit PageUp or
PageDown etc.

Plan B Do Alt-GAdvancedLastCellReturn

Eagleone

Stephen wrote:

I have a condition when starting Excel (2002), instead of going to the last
used cell (when I saved and shutdown Excel), the sheet goes a cell halfway up
(it's the same cell every time). As the sheet grows, this becomes a nuisance.
Does anyone have an idea how to force Excel to go to last entered cell? I
tried a suggestion sometime ago, which involved entering a line of code into
an active cell, but this has not worked. Any suggestions would be greatly
appreciated :) (Excel novice BTW)
Thanks in advance.