VPageBreaks.Add Method (Excel)
Adds a vertical page break.
Syntax
expression .Add(Before)
expression A variable that represents a VPageBreaks object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Before |
Required |
Object |
A Range object. The range to the left of which the new page break will be added. |
Return Value
A VPageBreak object that represents the new vertical 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