Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Dear advance excel user:
I had a small vb macro, try to solve 2 qadratic eq with 2 variable ---------------------------------------------------------------- Sub Macro1() 'To run a macro in Excel, you must set the Solver reference in VBA/Tools/References 'sets variables cells, there is not objective in your system of nonlinear equations ret = SolverOk(MaxMinVal:=1, ValueOf:="0", ByChange:="$E$7:$F$7") 'adds constraints. ret = SolverAdd(CellRef:="$E$9:$E$10", Relation:=2, FormulaText:="$F$9:$F$10") 'solves problem SolverSolve End Sub ------------------------------------------------------------------ when I run it , a window popup say internal error, exhaust memroy what may go wrong? please help eric |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date macro | Excel Discussion (Misc queries) | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
Macro and If Statement | Excel Discussion (Misc queries) | |||
Macro Formula revision? | Excel Worksheet Functions | |||
Macro for multiple charts | Excel Worksheet Functions |