L
Leog
Hi,
I have written a macro to calculate a result based on 5 variables and then
uses these variables to analyse a column of values.
I would like to use the solver addin to work out the optimal combination of
these 5 variables. However running the solver does not trigger the macro to
run.
The macro is set so that if any of the 5 variables are changed, the macro is
triggered.
Where am I going wrong.
Any help would be appreciated.
I have written a macro to calculate a result based on 5 variables and then
uses these variables to analyse a column of values.
I would like to use the solver addin to work out the optimal combination of
these 5 variables. However running the solver does not trigger the macro to
run.
The macro is set so that if any of the 5 variables are changed, the macro is
triggered.
Where am I going wrong.
Any help would be appreciated.