Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Solver
Hello,
I would like to run a macro in order to running 4 solvers with one action Could you please tell me why this code does not work. Thanks in advance AngelikiS Sub BestFit() ' BestFit Macro Dim solverok As variant ' Keyboard Shortcut: Ctrl+z solverok SetCell:="$E$19", MaxMinVal:=3, ValueOf:="0", ByChange:="$E$3:$E$4" SolverSolve solverok SetCell:="$F$19", MaxMinVal:=3, ValueOf:="0", ByChange:="$F$7:$F$8" SolverSolve solverok SetCell:="$G$19", MaxMinVal:=3, ValueOf:="0", ByChange:="$G$7:$G$8" SolverSolve solverok SetCell:="$H$19", MaxMinVal:=3, ValueOf:="0", ByChange:="$H$8" SolverSolve End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Solver
My guess is that if you insert the command SolverReset before eac invocation of the SolverOK, the code should work. I am a new Solver fa too msuryexce -- msuryexce ----------------------------------------------------------------------- msuryexcel's Profile: http://www.excelforum.com/member.php...fo&userid=2816 View this thread: http://www.excelforum.com/showthread.php?threadid=49332 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Solver or Other? | Excel Worksheet Functions | |||
how to add-in solver without cd | Excel Discussion (Misc queries) | |||
Interesting Solver problem (Solver encounters an error) | Excel Discussion (Misc queries) | |||
"solver" | Excel Discussion (Misc queries) | |||
Resetting Solver Manually to Fix Solver Bug | Excel Programming |