print area and page break help

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.