1004 Error - Application or object defined error

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

Originally Posted by Norie

Your formula mixes R1C1 and A1 notation, change it to use one or the other.

Thanks, how would I go about doing an absolute reference with R1C1 notation for two rows?

Yeah, columns, sorry.