title: vba insert array formula from range to end row?
body: <p>I am trying to insert an array formula down a column from row 10 onwards:</p>
  
  <pre><code>Sub Check()
  ActiveSheet.Range("L10").End(xlUp).Row.FormulaArray = "=IF(J10&lt;&gt;"",INDEX(Data!B:B,MATCH(1,(Home!H10=Data!C:C)*(Home!I10=Data!D:D)*(Home!J10=Data!E:E),0)),INDEX(Data!B:B,MATCH(1,(Home!H10=Data!C:C)*(Home!I10=Data!D:D)*(K10=Data!F:F),0)))"
  End Sub
  </code></pre>
  
  <p>For some reason this doesn't work and i get a object required error.
  I also want each cell refernce to go down with each row. I'm new to vba so apologies if my code is not great, but if someone could please point me in the right direction i'd really appreciate it?</p>
  
  <p>Thanks</p>