Setting formula for a Range is throwing an error

[jgscanlon]

Good morning -

Can anyone provide some thoughts on why the following line would throw a "Run-time error '1004': Application-defined or object-defined error" message?

Range("K5:K" & DestRow).FormulaR1C1 = "=VLOOKUP(RC1&RC2&RC3&RC6,'Custodian Data'C1:C13,9,FALSE)"

It must be something with the syntax, but I can't see it. I even tried recording this in the macro recorder, but my code matches what the macro recorder spits out.

Thank you

 

[Jonmo1]

You're missing the ! between the Sheetname and the Range.

 

[jgscanlon]

And, voila!

Thank you so much! That did the trick. Too many hours looks at this one.

Updated formula:

Range("K5:K" & DestRow).FormulaR1C1 = "=VLOOKUP(RC1&RC2&RC3&RC6,'Custodian Data'!C1:C13,9,FALSE)"

 

[Jonmo1]

You're welcome.