Excel.PivotField.LabelRange.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
PivotField.LabelRange property (Excel)	vbaxl10.chm240084	vbaxl10.chm240084	Excel.PivotField.LabelRange	be06bf39-d970-316e-6833-65efde85ddc8	05/04/2019	medium

PivotField.LabelRange property (Excel)

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

[!includeSupport and feedback]