Programatically Entering an Array Formula
 

I have a form that provides the user many options.

Once form has been completed, based on that information, I
wish to enter a formula into a worksheet cell using VBA.

Could someone share the syntax for doing this?

Programatically Entering an Array Formula
 

activeCell.Formula = "=Sum(A1:A10)"

if, as your subject implies, you want an array formula

ActiveCell.FormulaArray = "=Sum((B1:B10=""A"")*(C1:C10=""B"")*D1:D10)"

--
Regards,
Tom Ogilvy

"John C." wrote in message
...
I have a form that provides the user many options.

Once form has been completed, based on that information, I
wish to enter a formula into a worksheet cell using VBA.

Could someone share the syntax for doing this?