CubeFields.Item Property (Excel)
Returns a single object from a collection.
Syntax
expression .Item(Index)
expression A variable that represents a CubeFields object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Index |
Required |
Variant |
The name or index number of the object. |
Example
This example finds the first PivotTable report whose first cube field name contains the string “Paris”. The Boolean variable blnFoundName is set to True if the name is found.
blnFoundName = False
For Each objPT in ActiveSheet.PivotTables
Set objCubeField = _
objPT.CubeFields.Item(1)
If instr(1,objCubeField.Name, "Paris") <> 0 Then
blnFoundName = True
Exit For
End If
Next objPT