Hi There,
This is my first post so please forgive my ignorance. I read the forum rules and think I am not infringing them.
I have a problem related to optimization of a number of variables. I am calling the solver in a loop and I wrote a criterium function which resides in the Solver SetCell of the worksheet. The code works fine and the solver dumps all optimized variables once the loop is completed and the macro code ended. So far so good. However I would like to get better results by using the optimized variables from one step as starting values to calculate the optimized variables in the next step in the loop. I am not able to force solver to give the optimized variables in the completed step of the loop.
Conceptually the code looks like:
I really tried to find this on the Internet but did not succeed.
Any help is appreciated.
Thank you
Roel
Bookmarks