PivotItemList Collection [Excel 2003 VBA Language Reference]
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
Properties | Application Property | Count Property | Creator Property | Parent Property
Methods | Item Method
Parent Objects | PivotCell
Child Objects | PivotField | PivotItem | Range
See Also | PivotCache Object | PivotCell Object | PivotField Object | PivotFormula Object | PivotItem Object | PivotLayout Object | PivotTable Object