print area and page break help

[MATT.B]

logsheet example.xls
I'm still new to vb but I'm learning as I go. currently I'm working on a script to sent my number of pages and I'm having dificulty getting it right, in my example there is are cells in k2,l2,m2, that say where my page breaks should be. so far i was able to set a script that will do this for my now but my issue is i cant figure how to get it to work for setting the page break to between column I and column J
in the current example print area should be A1,I77 with page breaks at 19 and 47 but my script is adding a page break between column H,I when I need it to be between the I,J
any one know how to set this up
logsheet example.xls


to sum it up i need to modify my script so that when i print my page breaks will be the way they are currently set in the example

Please Login or Register  to view this content.

[MATT.B]

Please Login or Register  to view this content.

this is executed on print
It sets print area based on column B having text
then counts column B sets variables breakat, and breakau to where I want my page breaks
switches to pagebreak preview set breaks at this time it completes the print operation and goes back to normal view