I have the following line of code in my macro but it will not work. I keep getting that error message along with "Unable to get the VLookup property of the WorksheetFunction class.
After guessing and trying many different ways to fix it, I've given up. Any help would be greatly appreciated...
I can't seem to figure out why I am getting the runtime error 1004 (Application defined or object defined error)
For iRow = 2 To lrow
wsA.Cells(iRow, IDcol + 2) = WorksheetFunction.VLookup(wsA.Cells(iRow, IDcol + 1), wsB.Range("$A$1:$D$3000"), 3, False)