Collapse the table of content
Expand the table of content
Expand Minimize

PivotField.CubeField Property (Excel)


Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Returns the CubeField object from which the specified PivotTable field is descended. Read-only.

expression .CubeField

expression A variable that represents a PivotField object.

This example creates a list of the cube field names for all the hierarchy fields in the first Online Analytical Processing (OLAP) -based PivotTable report on the first worksheet. This example assumes a PivotTable report exists in the first worksheet.

Sub UseCubeField() 
 Dim objNewSheet As Worksheet 
 Set objNewSheet = Worksheets.Add 
 intRow = 1 
 For Each objPF in _ 
 If objPF.CubeField.CubeFieldType = xlHierarchy Then 
 objNewSheet.Cells(intRow, 1).Value = objPF.Name 
 intRow = intRow + 1 
 End If 
 Next objPF 
End Sub
© 2015 Microsoft