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.