Thread: vlookup in VBA
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Pierce John Pierce is offline
external usenet poster
 
Posts: 93
Default vlookup in VBA

I am using Excell 2000 with Windows 2000 Professional.
I am trying to get the result of a vlookup into a cell by using

For I = 2 To numrows
Cells(I, "F") = Evaluate("=VLOOKUP(cells(i, "B"),Box_Log,6)")

Next I

I get a "Compile Error: Expected list separator or )" at the "B".
What gives?