Option Explicit
Public ancL As Long
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
Cells(Application.Max(ancL, 1), ActiveCell.Column).Select
End Sub
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
ancL = Target.Row
End Sub