On each HPageBreak put border

I have sheet with few thousand rows and I need put border on each end of page of PrintArea
(there is also other formating but not important for this question).
Macro code is in excel file loaded from XLSTART and Oracle Forms software (via WebUtil) which generate a worksheet with data.

So when excel sheet has been wrote, webutil fire a macro (which is loaded by excel start) and it format a sheet.
I have solution with "for each cell" but when code is executed automatically, it detect HPageBreak, but first HPB miss for +2 rows
then next for +4 rows, +6 rows, and so on.

If I start manually macro, it work just fine.

Where I have problem, I'm unable to figure out what cause problem or I miss something?


Code I use:

Please Login or Register  to view this content.

I believe pagebreaks are just in between two pages, not after each page.

there is no question where HPageBreak exist. The question is why is such a behavior?

Sounds like 2 header rows repeated at every page.

You are almost right and your post let me find where problem exist.
When in same code I have page setup, set print area and HPageBreak find, pagebreak are set automatically, but without count a place for header&footer top and bottom margin.
those two values are add at end of macro execution. So this explain why my macro work good when I start it manually after page is already formated.