MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.