Excel adds extra, spurious page breaks
Posted on 2002-05-03
I have some Excel VBA macros which take a large text file and convert to an Excel formatted print. I maintain a line count of details lines, plus two types of total lines. I insert my own page breaks programmatically when I reach a certain line count, and I also take into account the 5 lines repeated as the page header. When the program ahs finished running, and I go into Print Preview or Page Break preview, I find that Excel has added its own Page Breaks usually in front of mine. I then have to go in and drag off the additional breaks so that they coincide with the ones I forced. The Excel breaks appear as dotted (broken) lines and mine as unbroken solid lines. How can I prevent Excel interfering with my program.