shortcut to go to previous location or cell
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?
|