PivotItem.Position Property (Excel)

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

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.

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

See Also

Concepts

PivotItem Object

PivotItem Object Members