I am dong a vlookup between two excel workbook, hence the names wbOld and wbNew.
I am not sure if the object, property, and method are in the correct format to execute the function.
wbOld.ActiveSheet.Cells(xOld, 21) = wbOld.Application.WorksheetFunction.VLookup(Cells(xOld, 19), wbNew.ActiveSheet.Range("S:T"), 2, False)
Thanks for your help.
This post has been edited by nquadr: 12 June 2012 - 05:27 AM