shortcut to go to previous location or cell

M

Max

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 ..
 
S

Stefi

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:
 
Top