title: Fill formula down till last row in column
body: <p>I'm trying to draw down the formula that's in cell M3 to the end of the data set.</p>
  
  <p>I'm using column L as my base to determine the last cell with data. My formula is a concatenation of two cells with a text comma in-between them.</p>
  
  <p>My formula is =G3&amp;","&amp;L3</p>
  
  <p>I want Excel to draw down this formula so</p>
  
  <p>Cell M4 would be =G4&amp;","&amp;L4<br>
  Cell M5 would be =G5&amp;","&amp;L5 and so on.</p>
  
  <p>My code: </p>
  
  <pre><code>Range("$M$3").Formula = Range("G3") &amp; (",") &amp; Range("L3")
  
  Dim Lastrow As Long
  
  Application.ScreenUpdating = False
  
  Lastrow = Range("L" &amp; Rows.Count).End(xlUp).Row
  Range("M4").FormulaR1C1 = Range("G4") &amp; (",") &amp; Range("L4")
  Range("M4").AutoFill Destination:=Range("M4:M" &amp; Lastrow)
  ActiveSheet.AutoFilterMode = False
  Application.ScreenUpdating = True
  </code></pre>
  
  <p>My output is pulling down the text values from cell M3 all the way down to the end of the data set. I've searched around for several hours trying to look for a fix, but can't find one that is trying to accomplish what I'm going for.</p>