XlPivotCellType Enumeration
Specifies the PivotTable entity to which the cell corresponds.
Version Information
Version Added: Excel 2007
| Name | Value | Description |
|---|---|---|
| xlPivotCellBlankCell | 9 | A structural blank cell in the PivotTable. |
| xlPivotCellCustomSubtotal | 7 | A cell in the row or column area that is a custom subtotal. |
| xlPivotCellDataField | 4 | A data field label (not the Data button). |
| xlPivotCellDataPivotField | 8 | The Data button. |
| xlPivotCellGrandTotal | 3 | A cell in a row or column area that is a grand total. |
| xlPivotCellPageFieldItem | 6 | The cell that shows the selected item of a Page field. |
| xlPivotCellPivotField | 5 | The button for a field (not the Data button). |
| xlPivotCellPivotItem | 1 | A cell in the row or column area that is not a subtotal, grand total, custom subtotal, or blank line. |
| xlPivotCellSubtotal | 2 | A cell in the row or column area that is a subtotal. |
| xlPivotCellValue | 0 | Any cell in the data area (except a blank row). |