Edit

Share via

PivotField.LabelRange property (Excel)

  • Article

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

Syntax

expression.LabelRange

expression A variable that represents a PivotField object.

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.