| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Writing Array Formulas in VBA
Anyone know how to assign an array formula to a cell
using VBA? If possible, I'd like to use 'A1' format. Follow on question: Complicating matters, the formula has quotes in it - how do I force the quotes through without VBA bugging out due to the extra quotes I'm putting around the formula |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Writing Array Formulas in VBA
Ed,
ActiveCell.FormulaArray = "=1+1" Not sure what you mean in your second question. Could you supply an example? Rob "Ed" wrote in message ... Anyone know how to assign an array formula to a cell using VBA? If possible, I'd like to use 'A1' format. Follow on question: Complicating matters, the formula has quotes in it - how do I force the quotes through without VBA bugging out due to the extra quotes I'm putting around the formula |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Writing Array Formulas in VBA
Ed,
I sometimes find the easiest way to get the correct quote configuration is to enter the formula into a cell with the macro recorder turned on, and then copy the resulting code. hth, Doug "Ed" wrote in message ... Anyone know how to assign an array formula to a cell using VBA? If possible, I'd like to use 'A1' format. Follow on question: Complicating matters, the formula has quotes in it - how do I force the quotes through without VBA bugging out due to the extra quotes I'm putting around the formula |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Writing Array Formulas in VBA
If I understand your second question, I believe you need to use double
quotes around text... Range("B1").Formula = "=If(A10,""Yes"",""No"")" -- Dana DeLouis Using Windows XP & Office XP = = = = = = = = = = = = = = = = = "Ed" wrote in message ... Anyone know how to assign an array formula to a cell using VBA? If possible, I'd like to use 'A1' format. Follow on question: Complicating matters, the formula has quotes in it - how do I force the quotes through without VBA bugging out due to the extra quotes I'm putting around the formula |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Writing Array Formulas in VBA
And try it using the A1 reference style.
the help is incorrect with this statement: If you use this property to enter an array formula, the formula must use the R1C1 reference style, not the A1 reference style (see the second example). Ed wrote: Anyone know how to assign an array formula to a cell using VBA? If possible, I'd like to use 'A1' format. Follow on question: Complicating matters, the formula has quotes in it - how do I force the quotes through without VBA bugging out due to the extra quotes I'm putting around the formula -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| writing formulas | New Users to Excel | |||
| writing if formulas | Excel Worksheet Functions | |||
| Writing Formulas | Excel Worksheet Functions | |||
| Problem writing formulas - please, please help! | Excel Programming | |||
| VBA: Writing an array function (like MMult) | Excel Programming | |||
Linear Mode
