| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Entering an array formula | Excel Worksheet Functions | |||
| entering formula in a numeric array | Excel Discussion (Misc queries) | |||
| entering as an array | Excel Discussion (Misc queries) | |||
| Entering Array Functions | Excel Discussion (Misc queries) | |||
| entering individual array formulas with vba | Excel Programming | |||
![John C.[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
