HPageBreak Object [Excel 2003 VBA Language Reference]
Multiple objects HPageBreaks HPageBreak 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.
Properties | Application Property | Creator Property | Extent Property | Location Property | Parent Property | Type Property
Methods | Delete Method | DragOff Method
Parent Objects | Charts | Sheets | Worksheet | Worksheets