Thread: insert formula in cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default 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?
Reply With QuoteReply With Quote