How to make a sheet the active sheet?

  • Thread starter Thread starter billw
  • Start date Start date
B

billw

If the user is on sheet 3, and I want the macro to be applied to sheet
2, how can I get the macro to make sheet 2 the active sheet?

tia
 
worksheets("sheet2").Activate


or
Application.Goto Reference:=Worksheets("Sheet2").Range("A1")



or you can just refer to Sheet2 and not make it the active sheet

With Worksheets("Sheet2")
.Range("A1").Value = 7
.Range("A1:A10").Interior.ColorIndex = 5
End with

as an example.
 
Back
Top