Pivot Cell Object

Represents a cell somewhere inside a PivotTable. You access the PivotCell object through the range object. Once obtained, you can use the various properties of the PivotCell object to retrieve data from a PivotTable. For example, you can use the PivotCellType, ColumnItems, and RowItems properties to locate a particular sales person's total sales for a specific region.

This object mirrors the functionality of the GETPIVOTDATA worksheet function and the GetPivotData method of the PivotTable object. The difference is that the PivotCell object can render information about where the cell is in the report. The GETPIVOTDATA worksheet function and the GetPivotData method do just the opposite. They yield the value associated with the row and column heading you provide.

0 0

Post a comment