CubeField.CubeFieldType procedure builder

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