HPageBreak object (Excel)

Represents a horizontal page break.

Remarks

The HPageBreak object is a member of the HPageBreaks collection.

Note

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

Example

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.

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

Methods

• Delete
• DragOff

Properties

• Application
• Creator
• Extent
• Location
• Parent
• Type

See also

• Excel Object Model Reference

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.