Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trigger Excel Solver by User Defined Function
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Solver as User Defined Funcntion | Excel Worksheet Functions | |||
Excel - User Defined Function Error: This function takes no argume | Excel Programming | |||
Solver in a User-Defined Function | Excel Programming | |||
Calling Excel user defined function from C# | Excel Programming | |||
How to create User Defined function in Excel | Excel Programming |