VBA / Excel 97 PageBreak Control
Posted on 1998-05-27
I need to take an existing XLS file and reformat it.
After changing the font size, the page breaks are
not positioned correctly. I plan to take out
all PageBreaks and then insert them based the contents
of cells in the first column. In other words
, the procedure I need is to end the page
when the "paragraph" is done and some pages
will have more white space at the bottom than
I attempt and fail to remove the PBs with:
For Each pb In Worksheets(2).HPageBreaks
Then I have to "rewind" and start putting PBs
back in passed on logic described above.
How do I remove all PBs.
Many thanks, Mark