Thread: combine Myvalue with formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
  
Posts: 9,101
Default combine Myvalue with formula
ActiveCell.FormulaR1C1 = "=RC[-9]+" & Myvalue


"Helmut" wrote:

Hi,

ActiveCell.FormulaR1C1 = "=RC[-9]+15.07"

I have this formula. the value 15.07 does change and i tried:

ActiveCell.FormulaR1C1 = "=RC[-9]+Myvalue"

but it doesn't work. How?
Reply With QuoteReply With Quote