![](/uploads/1/2/5/5/125584596/623257599.jpg)
CubeField object (Excel). 2 minutes to read.In this articleRepresents a hierarchy or measure field from an OLAP cube.
In a PivotTable report, the CubeField object is a member of the collection. ExampleUse the 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.AddobjNewSheet.ActivateintRow = 1For Each objPF in Worksheets('Sheet1').PivotTables(1).PivotFieldsIf objPF.CubeField.CubeFieldType = xlHierarchy ThenobjNewSheet.Cells(intRow, 1).Value = objPF.NameintRow = intRow + 1End IfNext objPFUse 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).NameMethods.Properties.See also.Support and feedbackHave questions or feedback about Office VBA or this documentation? Please see for guidance about the ways you can receive support and provide feedback.
Crazy contraptions game. Software ApplicationDisclaimerThis page is not a recommendation to uninstall Contraption Maker by Spotkin from your PC, nor are we saying that Contraption Maker by Spotkin is not a good application for your computer. This text only contains detailed instructions on how to uninstall Contraption Maker in case you decide this is what you want to do. The information above contains registry and disk entries that other software left behind and Advanced Uninstaller PRO discovered and classified as 'leftovers' on other users' computers.
Related Articles.
-->Represents a hierarchy or measure field from an OLAP cube. In a PivotTable report, the CubeField object is a member of the CubeFields collection.
Cubefield, the cult-classic. Traverse your way through an endless field of cubes in a tough, but fun, game of skill. Can you beat my high score of 190,003,880? Cubefield is an amazing ultimate running game that can be played online at browser. You just need to give your concentration. Avoid from hitting to any colored cubes and go as far as you can. Its an endless running game so the score define your skills among your friends. Lets start cubefield and score high.
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.
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.
In 2011, Tim Skern remarked (perhaps equivocally) that The Elements of Style 'remains the best book available on writing good English'. In 2013, Nevile Gwynne reproduced The Elements of Style in his work Gwynne's Grammar. Britt Peterson of the Boston Globe wrote that it was a 'curious addition'. The Elements of Style is the definitive text and classic manual on the principles of English language read by millions of readers. The 18 main topics are organized under the headings, “Elementary Rules of Usage,” “Elementary Principles of Composition,” “A Few Matters of Form,” “Words and Expressions Commonly Misused,” and “Words Often Misspelled.”. Elements of style pdf. Erin Tubridy Gates is the founder and principal designer of Erin Gates Design and is also the creator of the award winning design blog Elements of Style. Raised in Connecticut by a creative mother and self-taught architectural designer, Erin learned to love every aspect of the home building and decorating process from a very young age Read More.
Methods
Properties
See also
![Cubefield full screen Cubefield full screen](http://img.microsiervos.com/juegos/cubefield.jpg)
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.
![](/uploads/1/2/5/5/125584596/623257599.jpg)