Printing multiple ranges from multiple pages into one PDF

Hello,
I have been trying to find a solution to my problem without starting a new thread but have had no success. I currently have a project with 3 sheets, I have 1 desired range on each sheet. I have successfully produced the code needed to print all three ranges separately on three different sheets of paper. If I choose to save these ranges in their current configuration it will save 3 different PDF files. I would like to combine the 3 ranges and print one file with 3 pages so I can choose to save those 3 pages into 1 PDF file when I am done. Any help would be greatly appreciated.

Dustin

paste the ranges in a temporary worksheet and export it to PDF. Then delete the tempsheet.

Thank you for your response.
I did hear of this option before, my only holdup would be the fact that each range has its own column/row sizes and if I paste them below each other wont the arrangement be altered?
I also thought of copying as a picture then pasting into a temp worksheet, is there a way to add a page break below each pasted picture?

Dustin

Something like this:

Please Login or Register  to view this content.

Thank you 6StringJazzer for your assistance,
Here is the code that I have currently. I added a delay between each section since it prints 3 separate documents.

Dustin

Please Login or Register  to view this content.

Thank you for the assistance,
I was able to get the code to work in the sense that it did open one pdf file with all three worksheets merged into it. However, it did not only show the range that I had created. It instead shows every available row and column in the entire worksheet. What am I doing wrong??

Dustin

You are probably not doing anything wrong, but my tests are limited since I don't have your file. Let me look to see if there is a flag to include only the selection.

I have attached the PDF so you can see how it appears. The first and third pages should only show the cells with data. The last page is close but should zoom to the selection only. Im not sure if it makes a difference but all three of the ranges are dynamic name ranges.

thank you,
Dustin

OK, I got it this time. Note that if the names on the tabs of these three sheets changes, the code has to change. Also note that print areas are set permanently.

Please Login or Register  to view this content.

Amazing!!!!!!!!

Your awesome, thank you so much for the assistance.

Dustin