title: Print two different sheets on two different printers
body: <p>I'm trying to print different sheets (X &amp; Y) on two different printers (PrinterX &amp; PrinterY).</p>
  
  <pre><code>Dim PrinterX as string
  PrinterX=activeworkbook.Worksheets("Printers").Range("B1").value
  Activerprinter = PrinterX
  ActiveWorkbook.Worksheets("X").Printout
  
  Dim PrinterY as string
  PrinterY = Activeworkbook.Worksheets("Printers").Range("B2").value
  Activerprinter = PrinterY
  ActiveWorkbook.Worksheets("Y").Printout
  </code></pre>
  
  <p>==> I have the printer name in Range("B1") as "HP LaserJet Professional P1102 (Copy4) on Ne01" &amp; Range("B2") as "HP LaserJet Professional P1102 (Copy1) on Ne02".</p>
  
  <p>It prints both on PrinterX. I am trying to print X on PrinterX and Y on PrinterY.</p>
  
  <p><code>application.activeprinter</code> gives error.</p>