I coded the following, which worked beautifully in Excel 2003

Range("L2").Select
ActiveCell.FormulaR1C1 = "=VLOOKUP(RC10,Configuration!R1C1:R" &
lstRowConfig & "C2,2,FALSE)"

Now however, in 2007 in get in the cell
=VLOOKUP(RC10,Configuration!R1C1:R10C2,2,FALSE)

but it does not actually return a value, it jsut displays the formula????
In 2003 it returned the value and everything worked like a charm?

Any ideas why it no longer works and how to fix it.

Thank you,

QB