insert formula in cell
 

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?

insert formula in cell
 

Try

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

Mike

"Luc" wrote:

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?

insert formula in cell
 

Thks for your reply

same thing, still error message

"Mike H" wrote:

Try

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

Mike

"Luc" wrote:

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?

insert formula in cell
 

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

"Luc" wrote:

Thks for your reply

same thing, still error message

"Mike H" wrote:

Try

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

Mike

"Luc" wrote:

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?

insert formula in cell
 

gives me runtime error '1004'

"Mike H" wrote:

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

"Luc" wrote:

Thks for your reply

same thing, still error message

"Mike H" wrote:

Try

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

Mike

"Luc" wrote:

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?

insert formula in cell
 

Try this

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

Mike

"Luc" wrote:

gives me runtime error '1004'

"Mike H" wrote:

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

"Luc" wrote:

Thks for your reply

same thing, still error message

"Mike H" wrote:

Try

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

Mike

"Luc" wrote:

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?

insert formula in cell
 

small but relevant difference, thks a lot

"Mike H" wrote:

Try this

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

Mike

"Luc" wrote:

gives me runtime error '1004'

"Mike H" wrote:

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

"Luc" wrote:

Thks for your reply

same thing, still error message

"Mike H" wrote:

Try

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

Mike

"Luc" wrote:

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?