Worksheet.Activate Method (Excel)
Makes the current sheet the active sheet.
Syntax
expression .Activate
expression A variable that represents a Worksheet object.
Remarks
Calling this method is equivalent to clicking the sheet's tab.
Example
This example activates Sheet1.
Worksheets("Sheet1").Activate