HPageBreak Object (Excel)
Collapse the table of content
Expand the table of content
This documentation is archived and is not being maintained.

HPageBreak Object (Excel)

Represents a horizontal page break.

The HPageBreak object is a member of the HPageBreaks collection.

Note Note

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

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

Worksheets(1).HPageBreaks(1).Location = Worksheets(1).Range("e5")
© 2016 Microsoft