I have a macro printing 16 sheets at once, but each time I print it sends 3 different print jobs to the printer. How do I make it all one print job? Here is a section of my code:
Sheets(Array(sheet1, sheet2, sheet3, . . . sheet16)) _
.Select
Sheets(sheet16).Activate
ActiveWindow.SelectedSheets.PrintOut Copies:=1, _
Preview:=False, Collate:=False
Thanks in advance for any and all help
Sheets(Array(sheet1, sheet2, sheet3, . . . sheet16)) _
.Select
Sheets(sheet16).Activate
ActiveWindow.SelectedSheets.PrintOut Copies:=1, _
Preview:=False, Collate:=False
Thanks in advance for any and all help