insert formula in cell

[Luc]

trying following code to put a formula in a specific cell but get errormsg

Worksheets("Graphs").range("n4").FormulaR1C1 = "=VLOOKUP(M4;webdata!A4:E23;3)"

what am I doing wrong?

 

[Mike H]

Try

Worksheets("Graphs").Range("n4").Formula = "=VLOOKUP(M4;webdata!A4:E23;3)"

Mike

 

[Luc]

Thks for your reply

same thing, still error message

 

[Mike H]

It works for me, what error message do you get?

Thks for your reply

same thing, still error message

 

[Luc]

gives me runtime error '1004'

It works for me, what error message do you get?

 

[Mike H]

Try this

Worksheets("Graphs").Range("n4").Formula = "=VLOOKUP(M4,webdata!A4:E23,3)"

Mike

 

[Luc]

small but relevant difference, thks a lot

Try this

Worksheets("Graphs").Range("n4").Formula = "=VLOOKUP(M4,webdata!A4:E23,3)"

Mike