A
Awill
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.
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.