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

S

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
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to use Solver in Excel VBA 1
Solver iteration in VBA macro 2
Solver 0
SOLVER Reset command does not work in 2007Excel why???? Two Questi 0
Macro for solver on certain worksheets 2
Regarding excel and VBA 1
Solver marco still prompts to keep solution 1
Solver: An unexpected internal error occurred, or available memory was... 0

Top