Copy Page Breaks

[jwleonard]

WOW, thanks!

I really just wanted to know if it could be done. I didn't expect you
to do it for me!!! From the way you did this it looks like the message
box is not needed, this is a little different than what I had in mind
(it is better). I am going to attempt to remove those and then tailor
the code to my exact file. Thanks

 

[Dave Peterson]

I figured that it would be easier to really put the page breaks in the worksheet
once and test it with a few print previews then copy those would be the way I'd
want to do it.