Removing automatic page breaks

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

James Kampfe - 28 Apr 2004 00:18 GMT

Hi everybody,

I need to remove all existing page breaks, and then insert page breaks into
specific lines using a macro. I have no problem removing all manual page
breaks using Activesheet.ResetAllPageBreaks but the automatic page breaks
remain. I can't figure out how to get rid of the automatic page breaks.
Can anyone help. Thanks.

Jim Kampfe

Reply to this Message

David McRitchie - 28 Apr 2004 03:14 GMT

Hi Jim,
You can't get rid of automatic page breaks, they will change
as you insert/remove manual page breaks. You will have to start
your manual page breaks by looping from the beginning.
If you leave a big enough gap between manual page
breaks the automatic page break will force a page break,
I don't see a cause for concern.

It might even be possible for Excel to do your extra
page breaks for by using Data, Subtotals...
which you might look into if you are not familiar with them.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

> Hi everybody,
>
[quoted text clipped - 5 lines]
>
> Jim Kampfe

Reply to this Message

Rate this thread: