How to delete all page breaks?

I've been banging my head on my desk for a day trying to figure this out.
Does anyone have a working example of how to do this?

Thanks.

Hi Mchastant,

To remove all manual pagebreaks try:

Activesheet.Cells.PageBreak = xlPageBreakNone



---
Regards,
Norman



"mchastant" <mchastant@discussions.microsoft.com> wrote in message
news:B0C48CFD-06B0-410F-BDBB-E934D3CF4C74@microsoft.com...
> I've been banging my head on my desk for a day trying to figure this out.
> Does anyone have a working example of how to do this?
>
> Thanks.

How about automatic pagebreaks?

"Norman Jones" wrote:

> Hi Mchastant,
>
> To remove all manual pagebreaks try:
>
> Activesheet.Cells.PageBreak = xlPageBreakNone
>
>
>
> ---
> Regards,
> Norman
>
>
>
> "mchastant" <mchastant@discussions.microsoft.com> wrote in message
> news:B0C48CFD-06B0-410F-BDBB-E934D3CF4C74@microsoft.com...
> > I've been banging my head on my desk for a day trying to figure this out.
> > Does anyone have a working example of how to do this?
> >
> > Thanks.
>
>
>

Hi Mchastant,

> How about automatic pagebreaks?

Automatic page breaks cannot be deleted.

If you wish turn off the display of manual and automatic pagebreaks, try:

Application.DisplayPageBreaks = False


---
Regards,
Norman



"mchastant" <mchastant@discussions.microsoft.com> wrote in message
news:4E8E4C9F-2D65-40BE-86B9-1C764D4265A4@microsoft.com...
> How about automatic pagebreaks?
>
> "Norman Jones" wrote:
>
>> Hi Mchastant,
>>
>> To remove all manual pagebreaks try:
>>
>> Activesheet.Cells.PageBreak = xlPageBreakNone
>>
>>
>>
>> ---
>> Regards,
>> Norman
>>
>>
>>
>> "mchastant" <mchastant@discussions.microsoft.com> wrote in message
>> news:B0C48CFD-06B0-410F-BDBB-E934D3CF4C74@microsoft.com...
>> > I've been banging my head on my desk for a day trying to figure this
>> > out.
>> > Does anyone have a working example of how to do this?
>> >
>> > Thanks.
>>
>>
>>