Programatically Entering an Array Formula

J

John C.

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?
 
T

Tom Ogilvy

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)"
 
Top