This documentation is archived and is not being maintained.

Range.Worksheet Property

Office 2007
Returns a Worksheet object that represents the worksheet containing the specified range. Read-only.

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



Show: