Microsoft Office Tutorials and References
In Depth Information
20.10.3 PivotCellType Property
xlMin = -4139
xlMax = -4136
xlCountNums = -4113
xlCount = -4112
xlAverage = -4106
xlUnknown = 1000
End Enum
Note that if the PivotCell object is not of type xlPivotCellCustomSubtotal then any reference to
the CustomSubtotalFunction property generates an error, so it is important to check the
PivotcellType property (discussed below) before using the CustomSubtotalFunction property!
20.10.3 PivotCellType Property
This property returns the type of cell, in the form of one of the constants in the following
enumeration:
Enum XlPivotCellType
xlPivotCellValue = 0
xlPivotCellPivotItem = 1
xlPivotCellSubtotal = 2
xlPivotCellGrandTotal = 3
xlPivotCellDataField = 4
xlPivotCellPivotField = 5
xlPivotCellPageFieldItem = 6
xlPivotCellCustomSubtotal = 7
xlPivotCellDataPivotField = 8
xlPivotCellBlankCell = 9
End Enum
Figure 20-41 shows a pivot table and the PivotCellType values (on the right). You can use this to
see what types of cells are contained in a pivot table. For instance, cell A4 has PivotCellType 5,
indicating that it is a pivot field cell.
Figure 20-41. PivotCell values
20.10.4 PivotTable, PivotField, and PivotItem Properties
 
 
Search JabSto ::




Custom Search