CubeField.CubeFieldType (Excel)

Indicates whether the OLAP cube field is a hierarchy field or a measure field. Can be one of the XlCubeFieldType constants. Possible return values are xlHierarchy - OLAP field is a hierarchy, xlMeasure - OLAP field is a measure, xlSet - OLAP field is a set.

Dim xcfCubeFieldType As XlCubeFieldType
xcfCubeFieldType = ActiveCell.PivotField.CubeField.CubeFieldType