ExcelBanter - formula array gives compile error

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - formula array gives compile error (https://www.excelbanter.com/excel-programming/363405-formula-array-gives-compile-error.html)

R..VENKATARAMAN

formula array gives compile error

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

kounoike[_2_]

formula array gives compile error

Something like this ?

rng1.FormulaArray="=a1:a10+B1:B10"

keizi

"R..VENKATARAMAN" wrote in message
...
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

Ivan Raiminius

formula array gives compile error

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

All times are GMT +1. The time now is 10:22 AM.