title: Printing multiple ranges and worksheets to one PDF file
body: <p>I have a worksheet that often needs to be printed in a specific order of worksheets and ranges. What I'm trying to do is </p>
  
  <ol>
  <li>Print out specific worksheets and ranges in order to a single PDF file. </li>
  <li>Save the PDF file as a specific date to a certain folder.</li>
  </ol>
  
  <p>The obstacle I'm running into is getting the numerous sheets and ranges printed into one PDF file, as currently each worksheet or range prints out to its own single PDF file.</p>
  
  <p>I'm assuming there's a way to put all the necessary sheets and ranges in something like an array and then do a .PrintOut to that variable, however I haven't gotten this to work.</p>
  
  <p>I'm using Excel 2010 and so I just use the "Adobe PDF" Printer.  </p>
  
  <p>How can I print multiple ranges and worksheets to a single .pdf?</p>