title: Excel VBA autofill just return the formula
body: <p>I've created a macro and put it in the personal.xls file.
  The macro suppose to autofill the vlookup of J column in PhanCong.xls, but it just return exactly the formula.
  Here are a part of my Excel file, to illustrate what I say.</p>
  
  <p><img src="https://i.stack.imgur.com/cXpVq.jpg" alt="enter image description here"></p>
  
  <p>The first column should have the vlookup value, rather than the formula like that.
  Here are my macro, the part which autofill data.</p>
  
  <pre><code>        "C:\Users\khoale\Desktop\PhanCong.xls"
  Windows("test.xlsx").Activate
  ActiveSheet.Cells(2, 1).Activate
  ActiveCell.FormulaR1C1 = _
      "=VLOOKUP(RC[9],'[PhanCong.xls]Bang ma CC'!C1:C7,7,FALSE)"
  Dim autoFillRow As Long
  With ActiveSheet
  autoFillRow = .Range("C" &amp; Rows.Count).End(xlUp).Row
  End With
  Range("A2").Select
  Selection.AutoFill Destination:=Range("A2:A" &amp; autoFillRow), Type:=xlFillDefault
  </code></pre>