Export (0) Print
Expand All

Worksheet.Activate Method

Office 2007
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



Community Additions

ADD
Show:
© 2014 Microsoft