PivotCell Object
PivotCell
Multiple objects
Represents a cell (a grouping of data) in a PivotTable list. A cell displays aggregates, and if the underlying detail records are available, you can have the cell display a detail grid. Grouped fields on the row and column axis determine the amount of data that a given cell represents. Even a simple list with no grouped fields is really a single cell displaying a detail grid.
Using the PivotCell Object
The following properties return a PivotCell object:
-
The PivotAggregate , PivotDetailCell , and PivotDetailRange objects' Cell property
-
The PivotData object’s Cells , CellsEx , and CurrentCell properties
-
The PivotRange object’s BottomRight , Cells, and TopLeft properties