FormulaArray
 

Is there anyway of knowing if a cell contains a formula
or a formulaarray?

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?

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