title: Array Formula through VBA
body: <p>I am trying to write an array formula via VBA but getting an error " unable to set the FormulaArray property of the range class". I have tried both ' Range.FormulaArray' and '.Range.selection.FormulaArray' but nothing works. Thanks for helping me with this.</p>
  
  <pre><code>Worksheets("sheet1").Range("Table2[[" &amp; Me.cboSec.value &amp; " Row Score Max]]").FormulaArray = formulae
  </code></pre>