VBA Vlookup

[Monty]

Hello everyone one...

Am extremely sorry with no attachment for my query as am on my mobile.

My question how to use vlookup in VBA using workbook n sheet name?
Workbook name wb
Sourcebook name wb1
Sheet name sht1

Now need to pass this variable in lookup.

Example : =Vlookup(A1, wb1 sht1 range,0,1)

Hope not confused...

 

[AlanSidman]

Hopefully, this link will be helpful

http://www.cpearson.com/excel/CallingWorksheetFunctionsInVBA.aspx

 

[SirJB7]

Hi, Monty!
I don't think that the previous link answers your question. Give a look at these:
https://stackoverflow.com/questions/15658334/vba-vlookup-across-workbooks
https://stackoverflow.com/questions...th-defined-range-and-file-from-other-workbook
https://stackoverflow.com/questions...d-workbook-in-vlookup-formula-in-dowhile-loop
https://answers.microsoft.com/en-us...a-closed/5e5fe2dd-2190-4eef-9e72-f37c9e8383ef
Regards!

 

[Monty]

Thanks