I wrote a macro in order to solver some optimization problems. In general it works very well when the application runs up to 8 times.
When I try to solve problems where it is required to repeat the application in between 25 and up to 48 times, I face problems. Excel freezes.
Firstly, the first 10 solutions are found very quickly, up to one minute each, then the macro starts slowing down and it solves each problem at an average of 2- 5 minutes. This increase toward the end up to 10 minutes. Why?
Also this problem creates other problems to the spreadsheet. When I use the spreadsheet after run the macro, everything is low including moving between cells.
I suspect that while running the macro some data is stored in the spreadsheet and that is the problem.
Grateful if you could help me.
Elio
The Macro with 8 repeated problem is the following (this repeats 8 times)
Bookmarks