Item Property

                  Applies To

Returns a single object from the specified collection. The Item property is the default property for most collections, so it is usually not necessary to explicitly use this property. For more information about returning a single member of a collection, see Returning an Object from a Collection.

Syntax

expression.Item(Index)

expression   An expression that returns an object in the Applies To list.

Index   Required Variant. The name or index number of the object that will be returned.

Remarks

When applied to the Range object, the Item property can specify the row and column index numbers as two arguments instead of the cell index number as one argument. When two arguments are used, the first should specify the row containing the returned cell, and the second should specify the column containing the returned cell.