G
Guest
I try to get the vlookup results to a variable via a vba macro
however, the table of data is in book2 and my macro and active sheet is in
book1. Both books are on the same directory
I use excel2000 and windows xp and it does not work
the specific line of the vba is:
VLUV = application.worsheetfunction.vlookpu(27,book2!range("a1:g12"),3,false)
actually I'd rather like to use book2!table01 instead of the range function
but
none of this two ways work
please help
however, the table of data is in book2 and my macro and active sheet is in
book1. Both books are on the same directory
I use excel2000 and windows xp and it does not work
the specific line of the vba is:
VLUV = application.worsheetfunction.vlookpu(27,book2!range("a1:g12"),3,false)
actually I'd rather like to use book2!table01 instead of the range function
but
none of this two ways work
please help