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). |