For Each loop using vlookup not working

[hawkinsr86]

hi guys,

I am having problems with the following code. keep getting and error code 1004. can anyone help?

Please Login or Register  to view this content.

Thanks!

Moderator's Edit: Use code tags when you post code. To do so, select the code and click on the # icon above.

[TMS]

I suspect that it is your use of "row" as a range(?) variable. Row is an Excel/VBA reserved word and will be interpreted as a property of a range, particularly as you have not defined it.

Call it something else (that you have defined).

Regards, TMS