ActiveSheet Property

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

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"