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