XlPivotCellType Enumeration (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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

Show: