3 out of 11 rated this helpful - Rate this topic

Worksheet.Activate Method (Excel)

Published: July 16, 2012

Makes the current sheet the active sheet.

expression .Activate

expression A variable that represents a Worksheet object.

Calling this method is equivalent to clicking the sheet's tab.

This example activates Sheet1.

Worksheets("Sheet1").Activate

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.