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?
Last edited by jimmypants; 12-23-2011 at 05:18 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:
needs to have the "UserFinish:=True" command added after it.solversolve
In vivo, it looks like this:
Aw yeah, I could kiss the dudes who created Excel!SolverSolve UserFinish:=True
If I were a girl...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks