Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi everyone,
Say I am running an optimizer from Excel number of times, each time it assumes a different starting point. In a VBA code, I tell the model to write the solution into a table if a feasible solution is found. However, sometimes a solution gets reaptead! For eaxmple, say I am running the model 20 times and 12 runs deliver feasible solutions, I find that some of the 12 feasible solutions are just identical! So, what should I do to tell the model through VBA not to write down a feasible solution if it is already there? Thanks alot, Mike |