Vlookup in VBA error 1004 - can't figure out what's wrong.

Hello,

I have the following code:

Please Login or Register  to view this content.

The bolded section above is where I am getting the issue. There is a problem with my vlookup syntax and I can't figure out what it is.

- If I mouse over StepTwo.Name the correct value is there, WB2.xlsx
- I think I'm using the correct "RC" style syntax all the way through the formula
- I've tried the following after Data! to no avail
- C7:C7
- RC7:RC7
- RC[7]:RC[7]

What am I doing wrong here?

Originally Posted by judgeh59

deleted - never mind

So close.... yet so far.......

Originally Posted by judgeh59

Inserted single quotes

Please Login or Register  to view this content.

I love you. This was driving me NUTS!