View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Zimski Bob Zimski is offline
external usenet poster
 
Posts: 30
Default Formula Syntax Problem

I would like to end up with a cell to have =10+2 as the formula. I don't just
want the value of 12 dumped into the cell. My attempt is below but I can't
figure out why it bombs.

Range("C" & cntrl - 1).Formula = "=" & Range("C" & cntr1 - 1).value & "+" &
Range("C" & ctrl1).value

Thanks
Bob