Hello,
I am using solver to get the smallest SSE in an intricate model (it involves varying three variables). Unfortunately, it seems that sometimes running the solver more than once yields different results with varying accuracy. Can someone help me develop a macro that would have a constrain of running solver for a predetermined number of runs to arrive to an optimum answer (the minimum SSE). Note, I will be copying the worksheet multiple times, so it would be great if the macro runs in the sheet it’s executed in.
In advance I really appreciate the help,
Bookmarks