Solver VBA Macro

[josephbenfeld]

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)

Please Login or Register  to view this content.

[Alf]

Excel has a nasty habit of hogging memory, could this be your problem? Have you tried to shut down and restart Excel when it gets sluggish to see if this helps?

If possible post you workbook so somebody else can have a go at it.

You could also change your code a bit as using "Select" is not so efficient, so instead of:

Please Login or Register  to view this content.

try:

Please Login or Register  to view this content.