the range property HasArray will be true if it is part of an array formula

If hasarray is true, then the currentarray property returns a reference to
the range that contains the array formula.

the FormulaArray property is used to enter an array formula.

I believe it is restricted to a string length of 225 characters.

--
Regards,
Tom Ogilvy


"M. Authement" wrote:

I am trying to add functionality to an add-in by creating my own. Basically
I am going to:

1. Accept a user-entered range
2. Evaluate the formulas to determine if they came from the particular
add-in
3. Use some text evaluation/manipulation to find a position within the
formula and add an argument.
4. Enter this new formula.

The twist is that often times these formulas are array formulas. If the
user selects a range that contains multiple array formulas, or a mix of
array and non-array formulas, I need to be able to isolate each one. Any
ideas on how I accomplish this?