-
Don't have PDF creator, but for a regular printer if you have multiple worksheets selected (Ctrl+LMB) and Print, you get a single printout.
Might be worth seeing if you can do a single multi-sheet print to PDF creator
Here's the code I got with Recorder
[VBA]
Sub Macro1()
Sheets(Array("Sheet1", "Sheet2", "Sheet3", "Sheet4", "Sheet5")).Select
Sheets("Sheet1").Activate
Application.ActivePrinter = "CutePDF Writer on CPW2:"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _
"CutePDF Writer on CPW2:", Collate:=True
End Sub
[/VBA]
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules