| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert formula into cell | Excel Programming | |||
| Insert a formula into a cell | Excel Programming | |||
| Find a cell and then insert a formula into adjacent cell | Excel Programming | |||
| Using VBA to Insert a formula in a cell | Excel Programming | |||
| Insert value of formula into cell | Excel Programming | |||
![Luc[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
