Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I know that there is a lot written about that problem, but I almost tried everything. My macro lokks like that: Sub Macro2() SolverReset SolverAdd CellRef:="$P$736", Relation:=2, FormulaText:="$K$736" SolverAdd CellRef:="$Q$736", Relation:=2, FormulaText:="$I$736" SolverOk MaxMinVal:=1, ValueOf:="0", ByChange:="$V$736:$W$736" SolverSolve UserFinish:=True SolverFinish KeepFinal:=1 End Sub I tried with: solver.Auto_open and with Application.Run "Solver.xla!Auto_Open" and with macro: Sub AutoOpenSolver() If Not SOLVER.Solver1.AutoOpened Then SOLVER.Solver2.Auto_Open End If End Sub Can anybody help me ??? And other question. Is there possibility to make such a macro with for loop. For example (I know it is bad): Sub Macro2() Fok k = 1 to 10 SolverReset SolverAdd CellRef:="$P$736+k", Relation:=2, FormulaText:="$K$736+k" SolverAdd CellRef:="$Q$736+k", Relation:=2, FormulaText:="$I$736+k" SolverOk MaxMinVal:=1, ValueOf:="0", ByChange:="$V$736+k:$W$736+k" SolverSolve UserFinish:=True SolverFinish KeepFinal:=1 Next k End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Solver Error - an unexpected internal error has occurred | Excel Discussion (Misc queries) | |||
Solver Error - an unexpected internal error has occurred | Excel Discussion (Misc queries) | |||
Solver Error - an unexpected internal error has occurred | Excel Discussion (Misc queries) | |||
Solver: An unexpected internal error occurred, or available memory | Excel Programming | |||
WinXP: Solver: An unexpected internal error occurred ... | Excel Programming |