Remarks

The HPageBreak object is a member of the collection.

Note
There is a limit of 1026 horizontal page breaks per sheet.

Example

Use (), where is the index number of the page break, to return an HPageBreakobject. The following example changes the location of horizontal page break one.

Visual Basic for Applications 
Worksheets(1).HPageBreaks(1).Location = Worksheets(1).Range("e5")
H Page Break Object Hpagebreak object

See also:

index index