PivotItem.Position Property

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

• PivotItem Object
• PivotItem Object Members