VPageBreaks VPageBreaks VPageBreaks Interface


A collection of vertical page breaks within the print area. Each vertical page break is represented by a VPageBreak object.

public interface class VPageBreaks : System::Collections::IEnumerable
public interface VPageBreaks : System.Collections.IEnumerable
Public Interface VPageBreaks
Implements IEnumerable


Use the VPageBreaks property to return the VPageBreaks collection. Use the Add(Object) method to add a vertical page break.

If you add a page break that does not intersect the print area, then the newly-added VPageBreak object will not appear in the VPageBreaks collection for the print area. The contents of the collection may change if the print area is resized or redefined.

When the Application property, Count property, Creator property, Item[Int32] property, Parent property or Add(Object) method is used in conjunction with the VPageBreaks property:

For an automatic print area, the VPageBreaks property applies only to the page breaks within the print area.

For a user-defined print area of the same range, the VPageBreaks property applies to all of the page breaks.


_Default[Int32] _Default[Int32] _Default[Int32]

Reserved for internal use.

Application Application Application

Returns an Application object that represents the Microsoft Excel application.

Count Count Count

Returns the number of objects in the collection.

Creator Creator Creator

Returns a 32-bit integer that indicates the application in which this object was created.

Item[Int32] Item[Int32] Item[Int32]

Returns a single object from a collection.

Parent Parent Parent

Returns the parent object for the specified object.


Add(Object) Add(Object) Add(Object)

Adds a vertical page break. Returns a VPageBreak object.

GetEnumerator() GetEnumerator() GetEnumerator()

Applies to