title: How to save a sheet array to PDF with a specific sheet order
body: <p>I have a Workbook with multiple sheets which I want to select and convert to a single PDF file.</p>
  
  <p>I have written the following code which works fine and creates the file:</p>
  
  <pre><code>Sub Print_Project_Report_To_PDF
  
      Dim FilePathandName As String
      MyDate = Format(DateSerial(Year(Now), Month(Now) - 1, 1), "mmmm yyyy")
      MyPath = ThisWorkbook.Path &amp; "\"
      MyFile = "Project Progress Report - " &amp; MyDate &amp; ".pdf"
      FilePathandName = MyPath &amp; MyFile
  
      ThisWorkbook.Sheets(Array("PR_COVER_PAGE", "PR_SUMMARY", _
      "PR_PROJECT_DETAILS", "PR_INTERNAL RESOURCES", "PR_TIME", _
      "PR_REVENUE_FORECAST_SUMMARY", "PR_ORIGINAL_REVENUE_FORECAST", _
      "PR_ACTUAL_REVENUE_FORECAST", "PR_COSTS", "PR_ISSUES", "MONTHLY FINANCIAL    REPORT", _
      "PG-SC_COVER_LETTER", "PG-SC_CLAIM_SUMMARY", "PG-SC_TRADE", "PG-SC_HYDRAULICS", _
      "PG-SC_MECHANICAL", "PG-SC_MEDICAL_GASES", "PG-SC_ELECTRICAL", "PG-SC_VARIATION", _
      "PG-SC_MONTHLY_CASHFLOW", "PG-MH_COVER_LETTER", "PG-MH_CLAIM_SUMMARY", _
      "PG-MH_TRADE", "PG-MH_HYDRAULICS", "PG-MH_MECHANICAL", "PG-MH_MEDICAL_GASES", _
      "PG-MH_ELECTRICAL", "PG-MH_VARIATION", "PG-MH_MONTHLY_CASHFLOW", "CLIENT_COVER", _
      "CLIENT_SUMMARY", "CLIENT_ISSUES")).Select
  
      ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=FilePathandName, _
      Quality:=xlQualityStandard, IncludeDocProperties:=True, _
      IgnorePrintAreas:=False, OpenAfterPublish:=True
  
      ThisWorkbook.Sheets("Dashboard").Select
  
  End Sub
  </code></pre>
  
  <p>The problem is that the PDF file is not created with the sheets in order which I have specified in the array.  They are in the order which they appear in the Workbook (Left to right). It correctly only includes the sheets I want but not in the order i want.</p>
  
  <p>I dont want to change the order of the sheets in the Workbook either because it is setup in a specific, progressive way.</p>
  
  <p>Can anyone help me with code which will allow me to be specific with the order of the sheets when the document is published?</p>
  
  <p>Any help would be greatly appreciated.</p>