Collapse/Expand - Pivot table Fields - Need equivalent option in Excel VBA Pivot table

Guys,

can anyone help me out with the equivalent option in VBA for manipulating pivot table fields.... I want to expand and collapse the pivot table fields.... Plz chk the image....


1442-1.jpg

cheers,
Ragav

To collapse a field...

Please Login or Register  to view this content.

To collapse a pivot item within the field...

Please Login or Register  to view this content.

Change the names for the PivotTable, PivotField, and PivotItem, accordingly.