PivotCell Object

Multiple objects 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

Properties | Aggregates Property | ColumnMember Property | Data Property | DetailCells Property | DetailColumnCount Property | DetailRange Property | DetailRowCount Property | DetailTop Property | DetailTopOffset Property | Expanded Property | PageMember Property | Recordset Property | RowMember Property

Methods | MoveDetailTop Method

Parent Objects | PivotAggregate Object | PivotData Object | PivotDetailCell Object | PivotDetailRange Object | PivotRange Object

Child Objects | PivotAggregates Object | PivotColumnMember Object | PivotData Object | PivotDetailCell Object | PivotDetailRange Object | PivotPageMember Object | PivotRowMember Object