Error passing a range to the vlookup function

Hi,

I'm trying to pass a range to the worksheetfunction.vlookup method and I can't seem to get it to work. The code I have is below and I've inserted a comment where the error I get occurs.

Please Login or Register  to view this content.

When I try to run this it stops at

Please Login or Register  to view this content.

with the error "Runtime Error 1004 - Method 'Range' of object '_Global' failed."

Any suggestions on how I might remedy this would be most appreciated!

Kindest Regards,
Tim

snb,

Many thanks for the speedy response - the code is much more concise without all of the select lines.

When I run the code, I get a Run Time Error 13, Type Mismatch. Hovering over the selected code where the runtime error occurs, it seems like the vlookup is looking up the correct Arg1 value and it's looking at the correct sheet for Arg2. The Arguments 3 and 4 are correct. Could my syntax of the range for arg2 be incorrect?

Kindest Regards,
Tim