title: Using an entire sheet as the VLOOKUP table array
body: <p>I have a worksheet that is comprised entirely of just data.  The worksheet is declared &amp; set in code and I am keying off the first column in the sheet as well.</p>
  
  <p>I tried it and got an error, but was wondering if this is possible.  Can I set that entire sheet as a range that can be passed into the VLOOOKUP?</p>
  
  <p>.Cells(row, col) = WorksheetFunction.VLookup("key", sheetname, [SomeCol].Column, 0)</p>
  
  <p>Error is 1004: Unable to get the VLOOKUP property of the WorkSheetFunction class.</p>