DataLabelRange Property

Applies To

PivotTable Object.

Description

Accessor. Returns a Range object that represents the range that contains the PivotTable data field labels. Read-only.

See Also

ColumnRange Property, DataBodyRange Property, PageRange Property, RowRange Property.

Example

This example selects the data field labels in the PivotTable.

Worksheets("Sheet1").Activate
Range("A3").Select
ActiveCell.PivotTable.DataLabelRange.Select