Array Functions in VBA

Celia

From VBA,
-----------------------------------------------------------
Simple functions can be assigned:

Cells(5, 4).Formula = "=SUBTOTAL(9,D7:D" & FinalRow & ")"

Array functions can be assigned:

Cells(6, 15).FormulaArray = "=SUM(IF(L7:L300=""NO"",IF(M7:M300>0,D7:D300,"""")))"
-----------------------------------------------------------

I was going to ASK the question (regards to ARRAY in VBA) but thought better of it and decided to try the macro recorder first.

And, I tried the macro recorder first just for you Celia!!!

Bill