title: Converting Recorded VLookUp formula in R1C1 into VBA formula using A1 reference
body: <p>I have this recorded macro that I want to convert to plain VBA macro code and copy the formula from <code>AE2</code> to lastrow.</p>
  
  <pre><code>"=VLOOKUP(RC[-22],'[test.xlsx]Sheet3'!C5:C6,2,0)" ' this is from another workbook
  </code></pre>
  
  <p>Trying to convert to VBA.</p>
  
  <pre><code>dim wbSLW as workbook
  dim wbSLWDir as String
  
  wbSLWDir = "C\Documents\test.xlsx" 'this is not the constant directory or file name
  set wbSLW  = workbooks.open(wbSLWDir)
  
  ThisWorkbook.Activate
  With Thisworkbook.Sheets(1)
     .Range("AE2") = "=VLOOKUP(I2," &amp; wbSLW &amp; "!E:F,2,0)" ' error line
  end with
  </code></pre>
  
  <p>When I've converted it, it returns <code>Object does not support this property or method</code>.</p>