Share via


CalculatedItems.Item Method (Excel)

Returns a single object from a collection.

Syntax

expression .Item(Index)

expression A variable that represents a CalculatedItems object.

Parameters

Name

Required/Optional

Data Type

Description

Index

Required

Variant

The name or index number for the object.

Return Value

A PivotItem object contained by the collection.

Remarks

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

Example

This example hides calculated item one.

Worksheets(1).PivotTables(1).PivotFields("year") _ 
 .CalculatedItems.Item(1).Visible = False

See Also

Concepts

CalculatedItems Object Members

CalculatedItems Collection