Hi everyone,
A new member here and had a question regarding print automation within VBA functionality.
I have setup macros in the past to print multiple sheets to a single PDF using something simple like this:
Sheets(Array("Sheet 1", "Sheet 2", "Sheet 3")).Select
Application.Dialogs(xlDialogPrint).Show
I have a few more complexities now and wish to print pages from multiple sheets.
Example:
I want to print a single PDF document containing->
Sheet 1 : Pages 1 - 5
Sheet 2 : Pages 1 - 2
Sheet 1 : Pages 6 - 7
Sheet 3 : Pages 1 - 2
Any help around how I would go about setting this up would be greatly appreciated.
Thanks,
Chris
Bookmarks