title: Excel FormulaR1C1 and FormulaArray
body: <p>I have the following table setup in Excel. I am looking to fill the remainder of the table with the array formula that I have successfully trialed in Column B.</p>
  
  <p><a href="https://i.stack.imgur.com/xmqyl.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/xmqyl.png" alt="enter image description here"></a></p>
  
  <p>The code below autofills the table, but not with an array formula, merely with the formula, so it does not return the required result. How do I change it so that the array formula is propogated? </p>
  
  <p>Note that the number of Users &amp; Courses does change hence the dynamic calculation of the range is a fixed requirement.</p>
  
  <pre><code>Dim LastCol As Long, LastRow As Long
  LastCol = Cells(2, Columns.Count).End(xlToLeft).Column
  LastRow = Cells(Rows.Count, "B").End(xlUp).Row
  Range("B3", Cells(LastRow, LastCol)).FormulaR1C1 Range("B3").FormulaR1C1
  </code></pre>