PivotCell Object
This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.
.gif "Aa198589.parchild(en-us,office.10).gif") PivotCell.gif "Aa198589.space(en-us,office.10).gif") |
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