Item Property (Worksheets Collection)

Applies To

Worksheets collection object.

Description

Returns a single Worksheet object from a Worksheets collection.

Syntax

expression.Item(Index)

expression Required. An expression that returns a Worksheets object.

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

Example

This example changes the location of vertical page break one.

Worksheets.Item(1).VPageBreaks(1).Location = .Range("E5")