Remove all manual page breaks

[Otto Moehrbach]

Excel 2002, WinXP
My code inserts manual page breaks here and there as needed prior to
printing. Bur prior to inserting these manual page breaks, I need for the
code to remove all the manual page breaks inserted in the previous run of
the code. How do I code the removal of all the manual page breaks?
PS: I am doing this for each sheet I need to print so I need to remove the
page breaks on only one sheet at a time as the code loops through the
sheets.
Thanks for your help. Otto

 

[Dave Peterson]

I recorded a macro when I selected all the cells and then did

Insert|Reset All Page Breaks

I got this relevant code:

ActiveSheet.ResetAllPageBreaks

 

[Otto Moehrbach]

Now I have to ask myself why I didn't think of that? Thanks Dave. Otto

 

[Guest]

I'm looking for help with using a macro to insert page breaks and am curious
what code you are using to insert page breaks.

Now I have to ask myself why I didn't think of that? Thanks Dave. Otto

 

[Norman Jones]

Hi Bking,

Try:

ActiveSheet.HPageBreaks.Add Before:=ActiveCell