Ouch, now that you mention it, it is a lot more visible here than in the VBA
editor window where the l and 1 are almost identical. as for the 'n', ...
been staring into the tube too long.

Thanks for the 'wake up call' :)

"Rick Rothstein" wrote:

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