View Single Post
  #3   Report Post  
Stefi
 
Posts: n/a
Default 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?