Item Property (Worksheets Collection)

       

Returns a single Worksheet object from a Worksheets collection.

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")