Item Property (HPageBreaks Collection)

Applies To

HPageBreaks collection object.

Description

Returns a single HPageBreak object from an HPageBreaks collection.

Syntax

expression.Item(Index)

expression Required. An expression that returns a HPageBreaks object.

Index Required Long. The index number of the horizontal page break.

Example

This example changes the location of horizontal page break one.

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