PivotItemList Collection

Microsoft Excel Visual Basic

PivotItemList Collection

PivotCell PivotItemList
PivotItem
Multiple objects

A collection of all the PivotItem objects in the specified PivotTable. Each PivotItem represents an item in a PivotTable field.

Using the PivotItemList collection

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

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