One way:

Application.GoTo Sheets("Sheet2").Range(Selection.Address)

In article ,
Gary''s Student wrote:

My user will select a range of cells in Sheet1 then I need some code that
will:

1. Activate Sheet2
2. Select the same range of cells in Sheet2 that the user selected in Sheet1

Thanks in advance