Hi XLD

Thanks for the feedback....

It still debugs on this line of code....

 .FormulaR1C1 = "=VLOOKUP(RC[2],'DATA!C[-1]:C[30],32,)"
Does it require anything before .Formula??