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.
This example changes the name of the active worksheet.
Spreadsheet1.ActiveSheet.Name = "Budget Sheet"