Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations GregLocock 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
Feb 21, 2003
3
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!
 
Replies continue below

Recommended for you

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