| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
Range.PivotField property (Excel) |
vbaxl10.chm144175 |
|
|
56003d2d-60cd-abd2-455e-4a4d3616a615 |
05/11/2019 |
medium |
Returns a PivotField object that represents the PivotTable field containing the upper-left corner of the specified range.
expression.PivotField
expression A variable that represents a Range object.
This example displays the name of the PivotTable field that contains the active cell.
Worksheets("Sheet1").Activate
MsgBox "The active cell is in the field " & _
ActiveCell.PivotField.Name[!includeSupport and feedback]