Edit

PivotItem.Position property (Excel)

  • Article

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.