A VBA code is used to print the file because after the first page - I need a footer inserted.

My only problem with this program is that it prints out the first page just fine, but upon printing the following page(s) - it carries part of what was on page one onto page two because the VBA also changes the margins.

To manually enter page breaks isn't beneficial because the number of rows hidden will vary with each use of this form.

Is there a way to write in the page breaks? If so - how would I write that code?


Thanks a bunch!
Sarr