title: Excel VBA choose cells to print - Set Print Area
body: <p>I want to choose the print area using VBA and print them out.</p>
  
  <p>I have tried this method, but it gives me an error</p>
  
  <blockquote>
    <p>This formula is missing a range reference or a defined name</p>
  </blockquote>
  
  <pre><code>Worksheets("Printable Version").Activate
  With Sheets("Printable Version")
      ActiveSheet.PageSetup.PrintArea = .Range("A1").Value &amp; ":" &amp; .Range("G55").Value
  End With
  </code></pre>