Syntax

expression.Item(Index)

expression A variable that represents a Sheets object.

Parameters

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

Example

This example activates Sheet1.

Visual Basic for Applications
Sheets.Item("sheet1").Activate

See also: