Range("E10:E34").Formula = "=Sum(C10:D10)"

--
Regards,
Tom Ogilvy


"Pete Collings" <Pete wrote in message
...
Using an Excel 2000 (9.0.2720) macro I want to sum two adjacent cells in a
row and display the result in the next cell in the row, and do this for a
column of figures. I have incremented the result output OK (it displayed
an[i]
error message with another formula), but cannot get the sum calculation to
work. using a cell reference of the type C[i] and D to increment the
sum
over the ranges C10:C34 + D10:D34