Hi,

did you mean something like this:
rng1.FormulaArray="=(a1:a10)+(B1:B10)"

regards,
Ivan

R..VENKATARAMAN wrote:
the following statements give compile error

Set rng1 = Worksheets("sheet1").Range("c1:c10")
rng1.FormulaArray="=range("a1:a10")+range("B1:B10" )

what is the mistake and what is the correct statement