I'm writing a report using VBA. As part of this process, I calculate the number of lines I have 'printed' and after a certain number (MaxReportLinesPerPage), when I am pointing to a blank line, I insert a manual page break. When I look at the worksheet afterwards, the page breaks are not where I put them (or, to be more exact, they are not where Excel says it is putting them).

This is the portion of code that determines whether or not to insert a page break: 
Please Login or Register  to view this content.
You will note that each time I do this I notify the user (via a msgbox) of:
Please Login or Register  to view this content.
The sequence of msgbox texts has the following variable values:
Please Login or Register  to view this content.
The ranges are going up by 28 lines each (which is what am hoping for) but the first page break occurs one line earlier than I am expecting.
Note that in every instance, I am placing 28 lines on the report. The first line is set at $A$4, which explains the fixed offset between the number of lines and the Range address.
(Each block of report lines is at least 3 lines of data, and possibly more, with a blank line between blocks. At present there are never more than three lines of data in a block.)

My core question is:
Why, when Excel reports that it is at $A32, and I insert a page break, does the page break actually show up just before $A$26? This is the only instance of inserting a pagebreak in the report procedure, so it does seem like Excel is not doing what it claims to do!?

MaxLinesPerReportRange is set to a value which should allow a block of lines to be printed, even if we have already reached the limit

Until I can answer that question, I can't make any progress to managing the more exact placement of report lines on the worksheet.

I know the answer is staring me in the face, but I can't see it when it's that close;-)

Tony

PS The spreadsheet is too large to upload, and it needs most of the worksheets to create the report.