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?

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?

Thanks Tom! That is exactly what I needed. I went to Google first and
found the .FormulaArray but not the other two.


"Tom Ogilvy" wrote in message
...
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?