title: Save as PDF in Landscape
body: <p>How can I pdf multiple sheets in my Workbook into one pdf in landscape format? Here is what I have. I am missing the landscape syntax -</p>
  
  <pre><code>Sub CompileReport()
  
      Sheets(Array("Sheet1", "Sheet2", "Sheet3")).Select
  
      ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:="F:\Report\Test" &amp; ".pdf", _
      Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False
  
  
  End Sub
  </code></pre>
  
  <p>Thanks!</p>