Returns a Worksheet object that represents the worksheet containing the specified range. Read-only.
expression.Worksheet
expression Required. An expression that returns a Range object.
This example activates the worksheet in Spreadsheet1 that contains the range named "Revenue."
Spreadsheet1.Range("Revenue").Worksheet.Activate