Item Property (Sheets Collection)

Applies To

Sheets collection object.

Description

Returns a single Chart or Worksheet object from a Sheets collection.

Syntax

expression.Item(Index)

expression Required. An expression that returns a Sheets object.

Index Required Variant. The name or index number of the sheet.

Example

This example activates Sheet1.

Sheets.Item("Sheet1").Activate