Alternatives to Application.evaluate(Long Formula)
 

I have a function that can calculate user-defined array formulas. The
variables are defined as named ranges in a sheet and are arrays. A formula is
passed to a function which uses FunctionResult =
Application.Evaluate(formula) to calculate the formula result. The formulae
are now too long for the Application.evaluate.

Is there a way around application.evaluate limitation or can anyone suggest
another way of calculating a string as a formula?

Any help would be greatly appreciated.

Alternatives to Application.evaluate(Long Formula)
 

Split the formula up into smaller strings.
--
Gary''s Student - gsnu200713

Alternatives to Application.evaluate(Long Formula)
 

Thanks for the reponse. I tried breaking the string or formula into smaller
parts, evaluate the small part and then incorporate it back into the original
formula.

The difficulty is that the variables are arrays so I have a lot of trouble
trying to incorporate the calculated array (from evaluating a portion of the
formula) back into the original formula for calculation.

Any ideas for incorporating the array back into a string formula for
calculation with application.evaluate?

"Gary''s Student" wrote:

Split the formula up into smaller strings.
--
Gary''s Student - gsnu200713