shortcut to go to previous location or cell

Is there a shortcut to take me back to the previous location (cell) that I
was in?

If there was an action done in the previous cell,
then perhaps ... click Undo?
(At the expense of undoing, of course,
and subject to the default max number of undo's)

Hang around awhile for better answers ..
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Jan" <[email protected]> wrote in message
news:[email protected]...
> Is there a shortcut to take me back to the previous location (cell) that I
> was in?

Hi Jan,

Maybe you can create a macro solution:
Create workbook-level public variables:

Private Sub Workbook_Open()
startcell = ActiveCell.Address
prevcell = ""
End Sub

Selection_Change event:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
prevcell = startcell
startcell = Target.Address
End Sub

Normal module:
Declarations
Public startcell As String
Public prevcell As String

Macros, assign a hotkey to this macro in :
Sub Goback()
Range(prevcell).Select
End Sub

Regards,
Stefi

„Jan” ezt �*rta:

> Is there a shortcut to take me back to the previous location (cell) that I
> was in?