here's the formula:


ActiveCell.FormulaR1C1 =
"VLOOKUP(LEFT(rc1,4)&"2"&RIGHT(rc1,LEN(rc1)-5)," & JobNumber &
"_keycodes!R1C1:R150C3,3,FALSE)"


-------




"Himansu" wrote in message
...
Hello everyone,

Anyone know what's wrong with this formula? It's embedded in a macro that
I'm writing.

--
Thanks,
Himansu