Syntax

expression.Worksheet

expression A variable that represents a Range object.

Example

This example displays the name of the worksheet that contains the active cell. The example must be run from a worksheet.

Visual Basic for Applications 
MsgBox ActiveCell.Worksheet.Name

This example displays the name of the worksheet that contains the range named "testRange."

Visual Basic for Applications 
MsgBox Range("testRange").Worksheet.Name
Can I find the worksheet for a named range. How do I tell which worksheet the active cell is in? worksheet Worksheet Property Worksheet property.

See also: