Share via


Worksheets.Item Property

Excel Developer Reference

Returns a single object from a collection.

Syntax

expression.Item(Index)

expression   A variable that represents a Worksheets object.

Parameters

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

Remarks

For more information about returning a single member of a collection, see Returning an Object from a Collection .

Example

Item is the default member for a collection. For example, the following two lines of code are equivalent.

Visual Basic for Applications
  ActiveWorkbook.Worksheets.Item(1)
ActiveWorkbook.Worksheets(1)

See Also