| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
FormulaArray
Is there anyway of knowing if a cell contains a formula
or a formulaarray? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
FormulaArray
MsgBox ActiveCell.HasArray
MsgBox ActiveCell.HasFormula Regards Pascal "UK" a écrit dans le message de ... Is there anyway of knowing if a cell contains a formula or a formulaarray? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
FormulaArray
What is a "formulaarray"? and when would I need/want to
use it? I'm having some trouble with a Grand total of Subtotals and the amount of text I can put into a cell using "=sum(" & myrange & ")". The myrange format is like A1 + A3 + A5 + . . . Sincerely, David Fixemer |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Re : Excel FormulaArray Copy-and-Paste via VBA | Excel Discussion (Misc queries) | |||
| FormulaArray | Excel Worksheet Functions | |||
| unable to set formulaarray of range class ERROR when using Conditional Sum | Excel Programming | |||
| FormulaArray and Formula prinicples | Excel Programming | |||
![UK[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
