PivotField.LabelRange Property

Syntax

expression.LabelRange

expression A variable that represents a PivotField object.

Example

This example selects the field button for the field named "ORDER_DATE."

Visual Basic for Applications
`Set pvtTable = Worksheets("Sheet1").Range("A3").PivotTable Set pvtField = pvtTable.PivotFields("ORDER_DATE") Worksheets("Sheet1").Activate pvtField.LabelRange.Select`

Returns a Range object that represents the cell (or cells) that contain the field label. Read-only