PivotItem.Position Property

Syntax

expression.Position

expression A variable that represents a PivotItem object.

Example

This example displays the position number of the PivotTable item that contains the active cell.

Visual Basic for Applications
`Worksheets("Sheet1").Activate MsgBox "The active item is in position number " & _ ActiveCell.PivotItem.Position`

Returns or sets a Long value that represents the position of the item in its field, if the item is currently showing.