PivotField.LabelRange Property

  • Article
Excel Developer Reference

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."

Visual Basic for Applications 
  Set pvtTable = Worksheets("Sheet1").Range("A3").PivotTable
Set pvtField = pvtTable.PivotFields("ORDER_DATE")
Worksheets("Sheet1").Activate
pvtField.LabelRange.Select

See Also