esu4236
asked on
Recalculate automatically when using Solver
Is there a way to have Excel automatically recalculate a Solver formula if you just change one of the input cells without having to go in and click on "Solve?"
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks so much!
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
To do this
- record a macro for the solver process
The recorded macro would look something like
Sub Macro1()
.
.
.
End Sub
- right-click on the sheet name and click on "View code" and paste the following code lines. Replace the dots here with whatever was recorded above in place of the dots
Sub worksheet_change()
on error resume next
.
.
.
end sub