Worksheet Property
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.
Example
This example activates the worksheet in Spreadsheet1 that contains the range named "Revenue."
Spreadsheet1.Range("Revenue").Worksheet.Activate