PivotItemList Object

Remarks

Each PivotItem represents an item in a PivotTable field.

Use the RowItems or ColumnItems property of the PivotCell object to return a PivotItemList collection.

Example

Once a PivotItemList collection is returned, you can use the Item method to identify a particular PivotItem list. The following example displays the PivotItem list associated with cell B5 to the user. This example assumes a PivotTable exists on the active worksheet.

Sub CheckPivotItemList() ' Identify contents associated with PivotItemList. MsgBox "Contents associated with cell B5: " & _ Application.Range("B5").PivotCell.RowItems.Item(1) End Sub

See also:

• Excel Object Model Reference
• PivotItemList Object Members
• PivotCache Object
• PivotCell Object
• PivotField Object
• PivotFormula Object
• PivotItem Object
• PivotLayout Object
• PivotTable Object