Hello all:
Can anyone please let me know how can I generate a user defined function(UDF) that triggers excel's solver?
I have a set of 5 constraints and one objective that is to be maximized. I want to perform a senstivity analysis for my objective changing these 5 constraints. So I want the UDF to take all the 5 constraints and return me the optimized value (obtained from excel's solver) for the objective cell.
I appreciate your help in this regard.
Thanks.
http://vbaexpress.com/forum/showthread.php?t=11715
Thread locked. Duplicate above with responses and crossposts.
If you have posted the same question at multiple forums, please read this IMPORTANT INFO.
Please use the thread tools to mark your thread Solved
Please review the Knowledge Base
for samples and solutions , or to submit your own!
Posting Permissions
