ActiveSheet Property

Returns a read-only Worksheet object that represents the active worksheet.

expression.ActiveSheet

*expression   * Required. An expression that returns one of the objects in the Applies To list.

Example

This example changes the name of the active worksheet.

Spreadsheet1.ActiveSheet.Name = "Budget Sheet"

Applies to | Spreadsheet Object | Window Object | Workbook Object

See Also | ActiveCell Property