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"