DataLabelRange Property

Microsoft Excel Visual Basic

previous page next page

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

Example

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

Worksheets("Sheet1").Activate
Range("A3").Select
ActiveCell.PivotTable.DataLabelRange.Select
previous page start next page