Help! Struggling with Page Breaks...

R

Randy Numbers

I'm trying to control page breaks with a macro. I can insert breaks OK, but
how do I get rid of the ones that had been inserted automatically?

I tried playing with <hpagebreak.type> but don't really know how to use it.


I'd like to loop through and check each row to see if it is an automatic
break, and delete it if so.

Many thanks../RN
 
B

BrianB

I don't think you can delete automatic pagebreaks.

The answer is to put manual pagebreaks in such a way that the page
will fit on to the paper, when there is no need for automatic breaks
so they are not produced
 
R

Randy Numbers

Thanks for your help... I've tried that, and the automatic breaks don't seem
to be going away, so I end up with pages with just a few lines on them.

What am I doing wrong? Thanks.../RN
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Delete Multiple Page Breaks w/in Selected Rows 6
Excel Tables and Page Breaks 1
help with page breaks 1
Page breaks 1
Trouble with a page break 1
Setting Page Breaks 10
Missing Page Breaks 4
Inserting page breaks 3

Top