Muokkaa

Jaa

VPageBreaks.Add method (Excel)

  • Artikkeli

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

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.