run time error 1004

[xzaqus]

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)
Next iRow



Thanks.

 

[xzaqus]

Any help will be appreciated.

Thanks.

 

[Logit]

.
It would be best if you posted your entire code, and specify where the error is highlighting.

Having a sample workbook with your code is the best method. You could post it on a cloud site for review (DropBox, Google, Amazon Cloud, etc.)

 

[Fluff]

It would help if you could post the entire code.
What are lrow, IDcol, wsA & wsB
Also are you sure that the value exists in col A of your lookup range?

 

[xzaqus]

Hello all,

It was due to N/A results from the vlookup. Corrected the issue with on error resume next.

Thank you for looking into this.

 

[Fluff]

Glad it's sorted & thanks for the feedback