Alternatives to Application.evaluate(Long Formula)

G

Guest

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.
 
G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA / Formula 2
Using user function (vba) with sqrt(array)-only first answer 1
Ranges in VBA 4
Using code to edit spreadsheet formulas 5
Code a long array formula 2
Referring to "previous cell" in a formula in a "varying current ce 2
Use cell contents to make formula reference 4
Can I trap "formula too long"?? 3

Top