Simulate same cell selection in 2 or more worksheets

[Mr Novice]

Can someone help me with this one please

I have a spreadsheet with 2 tabs (worksheets) Tab 1 and Tab 2
I would like which ever cell I have selected in Tab 1 to be the same in Tab 2.
So as I move around to different cells in Tab 1 the same thing happens in Tab 2
Is this possible?
Many thanks in advance.

 

[mikerickson]

A range cannot be selected unless it is on the active sheet.
You could put this in the sheet's code module for each of the sheets. When putting in the Sheet2's code module, change the referece to Sheet 1

' in code module for Sheet1

Public LastSelect As Range

Private Sub Worksheet_Activate()
    Me.Range(Sheet2.LastSelect.Address).Select
End Sub

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

 

[footoo]

Select Tab2, hold down Ctrl, select Tab1.
Make your selections in Tab1.

Alternatively, put this in the Tab1 module :

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim a$
Application.EnableEvents = False
a = Target.Address
Sheets("Tab2").Select
Sheets("Tab2").Range(a).Select
Sheets("Tab1").Select
Application.EnableEvents = True
End Sub

 

[Mr Novice]

Thank you mikerickson and footoo both codes worked perfectly.
Exactly what I was trying to achieve.