PDA

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