This documentation is archived and is not being maintained.

PivotTable.DataLabelRange Property (Excel)

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

expression .DataLabelRange

expression A variable that represents a PivotTable object.

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

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