View Full Version : Remove all Page Breaks
ProteanBeing
03-13-2008, 07:02 AM
The help on Excel stated that doing this
Cells.PageBreak = xlPageBreakNone
would remove all the pagebreaks on the sheet. Did I do something wrong?
paulked
03-13-2008, 07:29 AM
My help gave me this:
http://vbaexpress.com/forum/C:\Documents and Settings\user\Desktop\1.gif
ResetAllPageBreaks Method
See AlsoApplies ToExample (mk:@MSITStore:C:\Program%20Files\Microsoft%20Office\OFFICE11\1033\vbaxl10. chm::/html/xlmthResetAllPageBreaks1.htm#example)Specifics
Resets all page breaks on the specified worksheet.
expression.ResetAllPageBreaks()
expression Required. An expression that returns a Worksheet object.
Example (http://vbaexpress.com/forum/)
This example resets all page breaks on worksheet one.
Worksheets(1).ResetAllPageBreaks
Powered by vBulletin® Version 4.2.5 Copyright © 2025 vBulletin Solutions Inc. All rights reserved.