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.

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.

Look in the ThisWorkbook module for event code

--
Don Guillett
SalesAid Software

"Stephen" wrote in message
...
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.

I used the last used cell in column A of Sheet1. Change this as required:

Option Explicit
Sub auto_Open()
With Worksheets("Sheet1")
Application.Goto .Cells(.Rows.Count, "A").End(xlUp), _
scroll:=True
End With
End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

If you want to go to the cell below that (for the next entry?), use this line:

Application.Goto .Cells(.Rows.Count, "A").End(xlUp).offset(1,0), _
scroll:=True

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.

--

Dave Peterson