Edit

Share via


Range.PageBreak Property

Definition

Returns or sets the ___location of a page break.

public:
 property int PageBreak { int get(); void set(int value); };
public int PageBreak { get; set; }
Public Property PageBreak As Integer

Property Value

Remarks

The return value can be one of the following XlPageBreakconstants:

  • xlPageBreakAutomatic
  • xlPageBreakManual
  • xlPageBreakNone

This property can return the ___location of either automatic or manual page breaks, but it can only set the ___location of manual breaks (it can only be set to xlPageBreakManual or xlPageBreakNone).

To remove all manual page breaks on a worksheet, set Cells.PageBreak to xlPageBreakNone.

Applies to