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?
|