Worksheet.Activate Method

Excel Developer Reference

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.

Visual Basic for Applications
  Worksheets("Sheet1").Activate

See Also