PivotTable.DataLabelRange Property

Syntax

expression.DataLabelRange

expression A variable that represents a PivotTable object.

Example

This example selects the data field labels in the PivotTable report.

Visual Basic for Applications
`Worksheets("Sheet1").Activate Range("A3").Select ActiveCell.PivotTable.DataLabelRange.Select`

Access the data labels for a pivot table? data label range Data Label Range Property DataLabel DataLabelRange DataLabelRange Property Pivot datafield datalabels?

Returns a Range object that represents the range that contains the labels for the data fields in the PivotTable report. Read-only.

See also: