Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is there a property that returns whether or not the formula in a cell is an
array formula? I can insert a formula or an array formula into a cell no problem, but regardless of which way I insert it both the .Formula and the .FormulaArray properties return identical strings. I would've thought that one or the other would return empty. The following Debug.Print statements show identical strings whether I insert the formula string into .Formula or .FormulaArray Range("C1").Formula = "=SUM(IF(A1:A5=1,B1:B5))" Debug.Print Range("C1").FormulaArray Debug.Print Range("C1").Formula Range("C1").FormulaArray = "=SUM(IF(A1:A5=1,B1:B5))" Debug.Print Range("C1").FormulaArray Debug.Print Range("C1").Formula Any ideas? TIA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
What type of formula should I use? | Excel Discussion (Misc queries) | |||
Type of SUM formula ??? | Excel Discussion (Misc queries) | |||
Cannot see formula descriptions in worksheet as I type a formula. | Excel Worksheet Functions | |||
Look for a certain type of formula... | Excel Discussion (Misc queries) | |||
Just need to know what type of formula i would use for this | Excel Worksheet Functions |