Hi all, i got this code from this sit and need to change it to look at a
specific workbook and have tried different ways but keep getting errors;
PLEASE HELP !!!

EmailAddr = Application.Index(Worksheets("SupplierList").Range ("M:M"), _
Application.Match(mySuppNum,
Worksheets("SupplierList").Range("A:A"), 0))

I need it to look for mySuppNum in the workbook "Recon_Master" where the
worksheet ("SupplierList") is resident and then look up the e-mail
address in column M.


Thanks in advance.

Tempy

*** Sent via Developersdex http://www.developersdex.com ***