LabelRange Property

Applies To

PivotField object, PivotItem object.

Description

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

PivotItem object: Returns a Range object that represents all the PivotTable cells that contain the item. Read-only.

Example

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

Set pvtTable = Worksheets("Sheet1").Range("A3").PivotTable
Set pvtField = pvtTable.PivotFields("ORDER_DATE")
Worksheets("Sheet1").Activate
pvtField.LabelRange.Select