HPageBreaks.Add method (Excel)
Adds a horizontal page break.
Syntax
expression.Add (Before)
expression A variable that represents an HPageBreaks object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Before | Required | Object | A Range object. The range above which the new page break will be added. |
Return value
An HPageBreak object that represents the new horizontal page break.
Example
This example adds a horizontal page break above cell F25 and adds a vertical page break to the left of this cell.
With Worksheets(1)
.HPageBreaks.Add .Range("F25")
.VPageBreaks.Add .Range("F25")
End With
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.