page break in VBA


Posted by Karl DGama on July 16, 2001 11:07 AM

How can I remove vertical page break from an excel sheet through VBA ?



Posted by Ben O. on July 16, 2001 1:06 PM

Sub Macro1()
ActiveSheet.VPageBreaks(1).Delete
End Sub

Replace 1 with the number of the Break you want to delete.

-Ben O.