Search notes:

Excel: Page Setup -> Page Layout -> Breaks

*Page Layout* -> *Page Setup* -> Breaks allows to

Managing page breaks in VBA

In Visual Basic for Applications, page breaks can be managed like so:
activeSheet.hPageBreaks.add before := cells(5,3)
activeSheet.vPageBreaks.add before := cells(5,3)

activeSheet.hPageBreaks(1).delete
activeSheet.vPageBreaks(1).delete

activeSheet.resetAllPageBreaks

Index