Hi

I am trying to get VBA to enter a vlookup but I get a 1004 Run-time error, its the following piece of code that is causing the issue (there's another 7 or 8 rows similar to this afterwards, I then convert the formulas to values), I can't see anything wrong with it (New_EE_Id and WorkforceReport are defined as range and string).

New_EE_Id.Offset(0, 1).Formula = "=vlookup(RC[-1]," & WorkforceReport & "!$C:$D,2,FALSE)" 'Name