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
Properties
See also
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.
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for