Syntax

expression.PivotItems(Index)

expression A variable that represents a PivotField object.

Parameters

Name Required/Optional Data Type Description
Index Optional Variant The name or number of the item to be returned.

Return Value
Variant

Remarks

For OLAP data sources, the collection is indexed by the unique name (the name returned by the property), not by the display name.

Example

This example adds the names of all items in the field named "product" to a list on a new worksheet.

Visual Basic for Applications 
Set nwSheet = Worksheets.Add nwSheet.Activate Set pvtTable = Worksheets("Sheet2").Range("A1").PivotTable rw = 0 For Each pvtitem In pvtTable.PivotFields("product").PivotItems rw = rw + 1 nwSheet.Cells(rw, 1).Value = pvtitem.Name Next
pivot pivot items Pivot Items Method pivotitems pivotitems method

See also: