How to define table array in Vlookup function using VBA?
Thanks Bob, it works!
appreciated
Bob Phillips 写道：
Try
Application.VLookUp(Cells(1,1), COLUMNS(j).Resize(,2), 2 FALSE)
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
wrote in message
oups.com...
there's one integer variable, j.
I want to use VLookup function here, and the table Array parameter
should be Column j to j+1
But how to write this code in VBA?
Application.VLookUp(Cells(1,1), COLUMNS(j,j+1), 2 FALSE) ???
It report erros like above.
Thanks.
|