Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Alternatives to Application.evaluate(Long Formula)
Split the formula up into smaller strings.
-- Gary''s Student - gsnu200713 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Interpretation of Application.Caller.Parent.Evaluate | Excel Discussion (Misc queries) | |||
What is evaluate formula? | Excel Worksheet Functions | |||
Error 2015 with Application.Evaluate | Excel Programming | |||
Evaluate formula using VBA | Excel Discussion (Misc queries) | |||
?Application.Evaluate("max(len(A1:X20))") | Excel Programming |