Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

macro-izing solver in excel 3

Status
Not open for further replies.

AHeigley

Structural
Joined
Feb 21, 2003
Messages
3
Location
US
I have a macro that runs several different solver equations in a sheet. after each solver solution i have to click 'okay' to keep the solver solution, then it continues on to the next equation in the macro. is there a command that will automatically select the okay button to keep the solver solution, so i don't have to manually select okay in between each solver run? just trying to save myself some time and make it easier for someone else to use the program. thanks in advance!
 
Code:
SolverSolve userfinish:=True
would do!
 
Thanks yakpol! that worked great! i just couldn't find that command anywhere.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top