Make the current Active Cell Active on Another Worksheet

[rcb007]

I am trying to make a VBA command which will take the current active cell in the current worksheet1, then "go to" worksheet2 and make the same active cell in worksheet1 active.

Ideally, be able to select any cell in Column A (select the vba command), then it would go to worksheet2 and make the previous active cell; active in worksheet2.

Thank you.

 

[Fluff]

How about

Sub rcb()
   Application.Goto Sheets("Sheet2").Range(ActiveCell.Address)
End Sub

 

[rcb007]

Thank you! Simple is always nice!

 

[Fluff]

You're welcome & thanks for the feedback.