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