Formula Syntax Problem
It looks like you are using 3 different variable names (and I'm guessing
only one has a value assigned to it). The last character in your first Range
call is a lower case "L", in the other two Range calls it is the number 1,
but in the last Range call the variable does not have the lower case "N" in
it that the other two variables have.
--
Rick (MVP - Excel)
"Bob Zimski" wrote in message
...
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
|