Share via

CubeField.CubeFieldType Property

  • Article
Excel Developer Reference

Indicates whether the OLAP cube field is a hierarchy field or a measure field. Can be one of the XlCubeFieldType constants.

Syntax

expression.CubeFieldType

expression   A variable that represents a CubeField object.

Example

This example creates a list of cube field names for the measure fields in the first OLAP-based PivotTable report on Sheet1.

Visual Basic for Applications 
  Set objNewSheet = Worksheets.Add
objNewSheet.Activate
intRow = 1
For Each objCubeFld in Worksheets("Sheet1").PivotTables(1).CubeFields
    If objCubeFld.CubeFieldType = xlMeasure Then
        objNewSheet.Cells(intRow, 1).Value = objCubeFld.Name
        intRow = intRow + 1
    End If
Next objCubeFld

See Also