CubeField object (Excel)

Represents a hierarchy or measure field from an OLAP cube. In a PivotTable report, the CubeField object is a member of the CubeFields collection.

Example

Use the CubeField property of the PivotField object to return the CubeField object. This example creates a list of the cube field names for all the hierarchy fields in the first OLAP-based PivotTable report on Sheet1.

Set objNewSheet = Worksheets.Add 
objNewSheet.Activate 
intRow = 1 
For Each objPF in _ 
 Worksheets("Sheet1").PivotTables(1).PivotFields 
 If objPF.CubeField.CubeFieldType = xlHierarchy Then 
 objNewSheet.Cells(intRow, 1).Value = objPF.Name 
 intRow = intRow + 1 
 End If 
Next objPF

Use CubeFields (index), where index is the cube field's index number, to return a single CubeField object. The following example determines the name of the second cube field in the first PivotTable report on the active worksheet.

strAlphaName = _ 
 ActiveSheet.PivotTables(1).CubeFields(2).Name

Methods

• AddMemberPropertyField
• AutoGroup
• ClearManualFilter
• CreatePivotFields
• Delete

Properties

• AllItemsVisible
• Application
• Caption
• Creator
• CubeFieldSubType
• CubeFieldType
• CurrentPageName
• DragToColumn
• DragToData
• DragToHide
• DragToPage
• DragToRow
• EnableMultiplePageItems
• FlattenHierarchies
• HasMemberProperties
• HierarchizeDistinct
• IncludeNewItemsInFilter
• IsDate
• LayoutForm
• LayoutSubtotalLocation
• Name
• Orientation
• Parent
• PivotFields
• Position
• ShowInFieldList
• TreeviewControl
• Value

See also

• Excel Object Model Reference

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.