XlPivotCellType enumeration (Excel)
Specifies the PivotTable entity to which the cell corresponds.
| 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). |
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.