Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello;
Could someone please advise on how to check in a VBA macro if Solver has encountered a problem and could not find a solution ?? Basically, after loading and calling Solver, I would like to make sure that a solution has been found by Solver before continuing with the computations. -------------------------------------------------------- SolverOk SetCell:="$E$54", MaxMinVal:=1, ValueOf:="0", ByChange:= _ "$B$49,$F$54,$G$54" '....your statement ..... -------------------------------------------------------- And, if Solver is run manually from the Tool menu, is "Sover could not find a feasible solution" a run-time error ?? Thank you kindly. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Mouse scroll failure when looking at code | Excel Worksheet Functions | |||
Reference to solver problem | Excel Programming | |||
Chart versus Work Sheet Code Failure | Excel Programming | |||
Solver automatically in the VBA Reference | Excel Programming | |||
VBA code to add a reference to solver | Excel Programming |