solver: an unexpected internal error occurred, or available memory was exhausted

[sedelblut]

SolverOk MaxMinVal:=1, ValueOf:="0", ByChange:="$H$4,$F$15,$F$27"
SolverAdd CellRef:="$H$8", Relation:=2, FormulaText:="$I$8"
SolverAdd CellRef:="$L$15", Relation:=2, FormulaText:="$I$4"
SolverAdd CellRef:="$L$17", Relation:=2, FormulaText:="$I$4"
SolverSolve UserFinish:=True
SolverFinish KeepFinal:=1

tried solverreset, etc. does not work, What is wrong?

Thank You
Stephen

 

[sedelblut]

oh, i;m using excel 2003 in windows xp

 

[Graham Whitehead]

I seem to remember having the same problem a while ago. try adding the
following two lines at the beginning of your code:

Application.Run "Solver.xla!Auto_Open"
SolverReset