VPageBreaks.Add Method

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.

Visual Basic for Applications
`With Worksheets(1) .HPageBreaks.Add .Range("F25") .VPageBreaks.Add.Range("F25") End With`

Adds a vertical page break.