| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| help with this error-Compile error: cant find project or library | Excel Discussion (Misc queries) | |||
| VBAProject name compile error, not defined at compile time | Excel Programming | |||
| Help: Compile error: type mismatch: array or user defined type expected | Excel Programming | |||
| How do I get rid of "Compile error in hidden module" error message | Excel Discussion (Misc queries) | |||
Linear Mode
