HPageBreaks.Item Property (Excel)

Returns a single object from a collection.

Syntax

expression. Item( _Index_ )

expression A variable that represents a HPageBreaks object.

Parameters

Name Required/Optional Data type Description
Index Required Long The index number of the object.

Example

This example changes the location of horizontal page break one.

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

See also

HPageBreaks Object