Hi,
I have two tabs on the same worksheet, called 'Model' and 'Results'.
The Model tab (Sheet1) optimizes (minimizes) the cost on a project given some assumptions and constraints.
This is done using Excel's Solver add-in with the Evolutionary algorithm option
As Solver seems to output a different optimized cost amount for each round that Solver runs, I would like to be able to automate the running of Solver multiple times and record each run's results in the Results tab.
Attached pic is what I've come up with in terms of code.
First error is the line that begins with "ResultsArray=..."; the error window detects a "Subscription out of range" error.
I'd appreciate it if anybody could help me out with the rest of the code as well (see attached text file). Thanks
Bookmarks