Share via


PivotCell.PivotCellType Property (Excel)

Returns one of the XlPivotCellType constants that identifies the PivotTable entity the cell corresponds to. Read-only.

Syntax

expression .PivotCellType

expression A variable that represents a PivotCell object.

Remarks

XlPivotCellType can be one of these XlPivotCellType constants.

xlPivotCellBlankCell A structural blank cell in the PivotTable.

xlPivotCellCustomSubtotal A cell in the row or column area that is a custom subtotal.

xlPivotCellDataField A data field label (not the Data button).

xlPivotCellDataPivotField The Data button.

xlPivotCellGrandTotal A cell in a row or column area which is a grand total.

xlPivotCellPageFieldItem The cell that shows the selected item of a Page field.

xlPivotCellPivotField The button for a field (not the Data button).

xlPivotCellPivotItem A cell in the row or column area which is not a subtotal, grand total, custom subtotal, or blank line.

xlPivotCellSubtotal A cell in the row or column area which is a subtotal.

xlPivotCellValue Any cell in the data area (except a blank row).

Example

This example determines if cell A5 in the PivotTable is a data item and notifies the user. The example assumes a PivotTable exists on the active worksheet and cell A5 is contained in the PivotTable. If cell A5 is not in the PivotTable, the example handles the run-time error.

Sub CheckPivotCellType() 
 
 On Error GoTo Not_In_PivotTable 
 
 ' Determine if cell A5 is a data item in the PivotTable. 
 If Application.Range("A5").PivotCell.PivotCellType = xlPivotCellValue Then 
 MsgBox "The cell at A5 is a data item." 
 Else 
 MsgBox "The cell at A5 is not a data item." 
 End If 
 Exit Sub 
 
Not_In_PivotTable: 
 MsgBox "The chosen cell is not in a PivotTable." 
 
End Sub

See Also

Concepts

PivotCell Object

PivotCell Object Members