Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SolverSolve userFinish:=True still displays the dialogue
Hi
This is the first time I've ever queried a discussion group and I am VERY new to any kind of programming (not since the days of Fortran), so pardon if my terminology is inaccurate. I have created a VBA for applications macro which (successfully) runs Solver several times on a worksheet. Everywhere I've looked says inserting SolverSolve userFinish:=True means the dialogue at the end of the run won't be displayed, but in my case it still does!! Any ideas why? Also, if you don't display this dialogue how will you know if the Solve was successful? Any hints appreciated Alison ps: the code is: Sub Macro2() ' ' Macro2 Macro ' Macro recorded 29/09/2006 by ajoubert ' SolverOk SetCell:="$E$37", MaxMinVal:=2, ValueOf:="0", ByChange:= _ "$D$20:$D$24" SolverSolve SolverSolve userFinish:=True SolverOk SetCell:="$H$37", MaxMinVal:=2, ValueOf:="0", ByChange:= _ "$G$20:$G$24" SolverSolve SolverSolve userFinish:=True SolverOk SetCell:="$K$37", MaxMinVal:=2, ValueOf:="0", ByChange:= _ "$J$20:$J$24" SolverSolve SolverSolve userFinish:=True etc etc End Sub *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SolverSolve return values | Excel Programming | |||
SOLVER solversolve showref | Excel Programming | |||
Solver: 2nd function of SolverSolve | Excel Programming | |||
How does Solversolve Control Macro | Excel Programming | |||
True Or False, no matter what... it still displays the false statement | Excel Programming |