VPageBreak object (Excel)

Represents a vertical page break.

Remarks

The VPageBreak object is a member of the VPageBreaks collection.

Example

Use VPageBreaks (index), where index is the page break index number of the page break, to return a VPageBreak object.

Dim r as Range
Set r = Worksheets(1).VPageBreaks(1).Location

The following example changes the location of vertical page break one.

With Worksheets(1)
    .VPageBreaks(1).Delete
    .VPageBreaks.Add Before:=.Columns("E")
End With

Note

Location is read-only, and can only be used to return the current vertical page-break location. To change the location of a VPageBreak, you must use the Delete or Dragoff methods.

Methods

• Delete
• DragOff

Properties

• Application
• Creator
• Extent
• Location
• Parent
• Type

See also

• Excel Object Model Reference

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.