Hey All,
I'm hoping someone can point me in the right direction of what to do.
My situation is that I have 3 worksheets broken up with appropriate page breaks and need to print into one job in the sequence of: page 1 of sheet 1, then page 1 of sheet 2, page 1 of sheet 3, page 2 of sheet 1, etc...
The (incorrect) way I've tried to develop the macro is by setting it up like...
ThisWorkbook.Worksheets("Sheet1").PrintOut From:=1, To:=1
ThisWorkbook.Worksheets("Sheet2").PrintOut From:=1, To:=1
ThisWorkbook.Worksheets("Sheet3").PrintOut From:=1, To:=1
ThisWorkbook.Worksheets("Sheet1").PrintOut From:=2, To:=2
But this of course prints multiple jobs/files when I need to set it up into one job.
Can anyone help?
Thanks so much.
Bookmarks