Marco and VLOOKUP issue

[spectraflame]

I have a macro that enters in the following formula.

ActiveCell.FormulaR1C1 = "=VLOOKUP(RC3,WATER_COMMENTS,2,0)"

What is returned in the cell is just =VLOOKUP

Is there a better way of scripting this?

BTW - Using 2010 and the code worked great in 2000 before converting it.

 

[drsarao]

Works fine in 2003 also!

 

[spectraflame]

I know the the standard formula of =VLOOKUP(C2,WATER_COMMENTS,2,0) works if I key it in. It is just when I am trying to use a macro to input it.

I am going to breakdown the full macro into smaller pieces and see if I can determine if there is something else causing the issue.

 

[drsarao]

Try once the simpler version:
ActiveCell = "=VLOOKUP($C3,WATER_COMMENTS,2,0)"

(This too works in 2003)