Worksheet.ResetAllPageBreaks Method (Excel)
Resets all page breaks on the specified worksheet.
Syntax
expression .ResetAllPageBreaks
expression A variable that represents a Worksheet object.
Example
This example resets all page breaks on worksheet one.
Worksheets(1).ResetAllPageBreaks