title: How to assign an array of values to a range in Excel VBA
body: <p>I am creating column headers for a bunch of columns. I would like to do them in one like below - but I couldn't get the syntax right. Can anyone help?</p>
  
  <pre><code>Range("AB1:AE1").Value = ("UnitPriceUSD","TotalCostUSD","UnitPrice", "TotalCost")
  </code></pre>