Hi Kevryl:

You can create this feature within a single sheet:

In worksheet code enter:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Set oldr = r
Set r = Target
End Sub


In a standard module enter:

Public r As Range
Public oldr As Range
Sub goback()
If oldr Is Nothing Then
Else
oldr.Select
End If
End Sub


and assign a shortcut like CNTRL+e to goback. As you either click or arrow
around the sheet, CNTRL+e will return you to the previous selection.


REMEMBER: this will work only within a single sheet.
--
Gary''s Student - gsnu200715