Редагувати

Поділитися через

Range.Worksheet property (Excel)

  • Стаття

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.

MsgBox ActiveCell.Worksheet.Name

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

MsgBox Range("testRange").Worksheet.Name

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.