I have set up a macro for a worksheet so that I can customize the headers and footers for the first page, middle pages and last page. The middle page range consists of the 2nd page of a group, the 1st and 2nd pages of a group, and the 1st page of a group. The range then is a group of rows on the right half of the worksheet, group of rows on the left and right, and the a group of rows on the left side again. When printing (whether I choose Down, then over or Over, then down), it prints the 1st group of rows on the right of the sheet (correct) then prints the 2nd group of rows on the right of the sheet and then that same group on the left of the sheet (that's out of order), then correctly prints the last group of rows on the left of the sheet. Does anyone know a setting I may be missing so that it will print in the right order? Thanks!
Bookmarks