deleting pagebreaks in VB

[ragman]

How do I remove a pagebreak in Visual Basic? In the windows environment, I
just set the pagebreak to xlPageBreakNone, but Office.X doesn't know this
variable. What can I do?

Rags

 

[JE McGimpsey]

How do I remove a pagebreak in Visual Basic? In the windows environment, I
just set the pagebreak to xlPageBreakNone, but Office.X doesn't know this
variable. What can I do?

Rags

Using

Const xlPageBreakNone As Long = 0
Cells.PageBreak = xlPageBreakNone

still works, since setting Cells.Pagebreak to 0 removes all manual page
breaks. So does

ActiveSheet.ResetAllPageBreaks

or, to clear a single break:

ActiveCell.PageBreak = xlPageBreakNone