title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
---|---|---|---|---|---|---|---|---|
PivotItem.Position property (Excel) |
vbaxl10.chm246081 |
|
|
07e78622-f869-40d0-276a-b015ebe7a90f |
05/07/2019 |
medium |
Returns or sets a Long value that represents the position of the item in its field, if the item is currently showing.
expression.Position
expression A variable that represents a PivotItem object.
This example displays the position number of the PivotTable item that contains the active cell.
Worksheets("Sheet1").Activate
MsgBox "The active item is in position number " & _
ActiveCell.PivotItem.Position
[!includeSupport and feedback]