title: Printer setup via VBA in Excel
body: <p>I am trying to assign a cell in Excel for the user to type the printer name where they want the print out to go and then use that value in the </p>
  
  <pre><code>Application.ActivePrinter = (use the cell value)
  </code></pre>
  
  <p>Even though I have done the programming assigning a name to the cell and using it in a variable it is giving me an error.</p>
  
  <p>I have set my variable as string, text, object and variant already and it's not working.</p>
  
  <p>Do you know what code should I use to be able to do this?</p>