VBA Vlookup from another file

[Palucci]

I would like to make a vlookup function to another file which is my variable and paste it in this field :
wb.Sheets("C_0901").Range("D6") .
From this range of data:
wbMe.Sheets("res_mat").Range("A3:B6").Copy

I'm totally helpless I don't know how to do it

Please Login or Register  to view this content.

[Bernie Deitrick]

Are both workbooks open? What value are you looking for?

In VBA, you need to use the object model rather than the ! form of the reference: this will find the value from D6 in A3:A6 and return the matching value from B3:B6 (or an error) to the variant vRet:

Please Login or Register  to view this content.