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.

Visual Basic for Applications 
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

See also: