Writing Excel Macros with VBA, 2nd Edition

Name

PivotCell and PivotItemList Objects

Synopsis

Path: Application  --  Range - PivotCell - PivotItemList
               

Object	Methods	Properties
PivotCell		ColumnItems( ) As PivotItemList CustomSubtotalFunction( ) As XlConsolidationFunction DataField( ) As PivotField PivotCellType( ) As XlPivotCellType PivotField( ) As PivotField PivotItem( ) As PivotItem PivotTable( ) As PivotTable Range( ) As Range RowItems( ) As PivotItemList
PivotItemList	Item(Index As Variant) As PivotItem	Count( ) As Long

New to Excel XP is the PivotCell object, which represents a cell in a pivot table. For more on this object (and the PivotItemList object), please see Chapter 20.