Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
HPageBreak Object
Collapse the table of content
Expand the table of content

HPageBreak Object [Excel 2003 VBA Language Reference]

Office 2003
Multiple objects
Multiple objects

Represents a horizontal page break. The HPageBreak object is a member of the HPageBreaks collection.

Using the HPageBreak Object

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")

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

Parent Objects | Charts | Sheets | Worksheet | Worksheets

Child Objects | Range | Worksheet

© 2015 Microsoft