Posted to microsoft.public.excel.programming

Luc[_3_]

external usenet poster

Posts: 24

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Insert formula into cell	Karen53	Excel Programming	8	September 4th 07 02:26 AM
Insert a formula into a cell	jonco	Excel Programming	3	February 19th 07 10:32 PM
Find a cell and then insert a formula into adjacent cell	crowdx42[_8_]	Excel Programming	7	August 21st 06 02:53 PM
Using VBA to Insert a formula in a cell	Lee	Excel Programming	2	March 17th 06 01:23 AM
Insert value of formula into cell	Bill	Excel Programming	16	August 1st 05 06:16 PM

All times are GMT +1. The time now is 10:14 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us