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 wrote:
>
> 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

[Otto Moehrbach]

Now I have to ask myself why I didn't think of that? Thanks Dave. Otto
"Dave Peterson" <[email protected]> wrote in message
news:[email protected]...
>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 wrote:
>>
>> 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

[Bking]

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.

"Otto Moehrbach" wrote:

> Now I have to ask myself why I didn't think of that? Thanks Dave. Otto
> "Dave Peterson" <[email protected]> wrote in message
> news:[email protected]...
> >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 wrote:
> >>
> >> 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
>
>
>

[Norman Jones]

Hi Bking,

Try:

ActiveSheet.HPageBreaks.Add Before:=ActiveCell

---
Regards,
Norman


"Bking" <[email protected]> wrote in message
news:[email protected]...
> 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.
>