title: Using VLookup in VBA to reference another Excel file
body: <p>I'm trying to program a VLookup Table in VBA that references another file. Here is a simple outline of my goal:</p>
  
  <ul>
  <li>Look up value in cell A2 in another Excel file</li>
  <li>Pull the information in from column 2 of the other Excel file and place in Cell B2</li>
  <li>Move on to cell A3 and repeat the process until there are no more entries left in column A</li>
  </ul>
  
  <p>Here is the code that I already have. I keep getting an error that says "Unable to get the VLookup property of the WOrksheetFunction class." I checked the other posts referencing that error but they were not of any help. Do you all see an error in my code? Or does anyone have a better way of accomplishing this task?</p>
  
  <pre><code>Sub SBEPlannerAdder()
  
  Dim wbk As Workbook
  Set wbk = Workbooks.Open("C:\Users\user\Documents\Support File\Planner.xlsx")
  
  With Sheets("Sheet1")
  
      ' Selects the first cell to check
      Range("A2").Select
      Dim x As Variant
      x = wbk.Worksheets("Sheet1").Range("A1:C1752")
  
      ' Loops through all rows until an empty row is found
      Do Until IsEmpty(ActiveCell)
  
          Range(ActiveCell.Offset(0, 1) &amp; ActiveCell.Row).Value = Application.WorksheetFunction.VLookup((ActiveCell.Column &amp; ActiveCell.Row), x, 2, 0)
          ActiveCell.Offset(1, 0).Select
      Loop
  End With
  
  Call wbk.Close(False)
  End Sub
  </code></pre>