macro not keeping solver solutions when solver is successful

**jimmypants** · 12-23-2011, 05:12 PM

I created a macro that allows me to perform 12 Solver solutions in a row.
The formula is very reliable regarding the ease with which Solver can find a solution (no risk of errors or failure to find a solution).
Unfortunately, the macro does not keep the Solver solutions, even though I selected "keep solver solution" when recording the macro.
I tried adding ":select" after a "solversolve", but that created an error.

I need the macro to Keep all the Solver Solutions, so that I don't have to press Enter for every step of the macro. (My plans are to eventually create a macro that will process well over 1000 Solver solutions at one time.)

Is there a code command that I can insert after "solversolve" that will make Solver keep the solution and move on to the next step?

**jimmypants** · 12-23-2011, 06:16 PM

I figured it out! Woohoo!
Finally figured out how to get "Help" to work. Apparently I also had to select that in the "References" section of the VBA Tools menu. Then I clicked on "Help" and the VBA Editor asked me if I would like to install the Help feature. So I did... And so I was able to find the answer to my question.

Here is the solution to my problem:

Please Login or Register  to view this content.

needs to have the "UserFinish:=True" command added after it.
In vivo, it looks like this:

Please Login or Register  to view this content.

Aw yeah, I could kiss the dudes who created Excel!
If I were a girl...

**achyutsarat** · 06-10-2014, 01:45 AM

This really helped me with my work. There was a macro which i had been running using Goal Seek. The same macro in the same workbook suddenly started to take ages to reach a solution (i never actually waited till it reached.). There must have been issues with circular referencing. Anyways, without trying to figure it out, got another macro recorded with Solver. Only to be stumped first with the referencing problem and later with having to OK all solutions.

Thanks a ton for the post. It saved me a heap of trouble.