VPageBreak Object Members

  • Article
Excel Developer Reference

Represents a vertical page break.

Methods

  Name Description
Bb225751.methods(en-us,office.12).gif Delete Deletes the object.
Bb225751.methods(en-us,office.12).gif DragOff Drags a page break out of the print area.

Properties

  Name Description
Bb225751.properties(en-us,office.12).gif Application When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.
Bb225751.properties(en-us,office.12).gif Extent Returns the type of the specified page break: full-screen or only within a print area. Can be either of the following XlPageBreakExtent constants: xlPageBreakFull or xlPageBreakPartial. Read-only Long.
Bb225751.properties(en-us,office.12).gif Location Returns or sets the cell (a Range object) that defines the page-break location. Horizontal page breaks are aligned with the top edge of the location cell; vertical page breaks are aligned with the left edge of the location cell. Read/write Range.
Bb225751.properties(en-us,office.12).gif Parent Returns the parent object for the specified object. Read-only.
Bb225751.properties(en-us,office.12).gif Type Returns or sets a XlPageBreak value that represents the page break type.