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