Hi all,
I am doing an optimization problem, where I want to conduct an exhaustive
sensitivity analysis. My objectve cell (maximize NPV) has a solver output.
What I want to do is to change the 5 constraints in a pre-defined range and
see how the objective (NPV Value) is affected. I am new to
VB programming and
as such I dont have any idea to write a
VB macro or User Defined Function. I
want a UDF to take all the 5 constraints and return me the optimized value
(obtained from excel's solver) for the objective cell. Can anyone help me in
this regard?
Thanks.