PivotField.ChildItems (Excel)

Returns an pivotitem that represents either a single PivotTable item (a PivotItem pivotitem) or a collection of all the items (a PivotItems collection) that are group children in the specified field, or children of the specified item. Read-only.

This property is not available for OLAP data sources.

ChildItems (Index)

Index: The item name or number (can be an array to specify more than one item).

Dim pvtiChildItems As PivotItem
Set pvtiChildItems = ActiveCell.PivotField.ChildItems