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