Array Formula cell via Excel VBA

[andym]

Dear All,

I know that we can add a formula to a cell in VBA by:

Range(myRange).Formula = "=SUM(iRange)"

....but can anybody help me with an Array Formula? ... eg.. something
like

Range(myRange).Formula = "{=SUM((...)=...)*(....))}"

This obviously doesn't work... but is there a solution?

Regards,

andym

 

[Gary Keramidas]

use FormulaArray instead of Formula to enter an array formula

 

[Steel Monkey]

Try
Range(myRange).FormulaArray = "=SUMetcetc

Hope this helps

Steel Monke

 

[andym]

Gary,

fantastic!!! How easy was that!!!!

Regards,

andy..