Excel.PivotTables.Item.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
PivotTables.Item method (Excel)	vbaxl10.chm238074	vbaxl10.chm238074	Excel.PivotTables.Item	1bdc8558-ec67-2823-fd02-ecd5ae4ecee6	05/07/2019	medium

PivotTables.Item method (Excel)

Returns a single object from a collection.

Syntax

expression.Item (Index)

expression A variable that represents a PivotTables object.

Parameters

Name	Required/Optional	Data type	Description
Index	Required	Variant	The name or index number for the object.

Return value

A PivotTable object contained by the collection.

Remarks

The text name of the object is the value of the Name and Value properties.

Example

This example makes the Year field a row field in the first PivotTable report on Sheet3.

Worksheets("sheet3").PivotTables.Item(1) _ 
 .PivotFields("year").Orientation = xlRowField

[!includeSupport and feedback]