ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   run macro error, please help (https://www.excelbanter.com/excel-discussion-misc-queries/12004-run-macro-error-please-help.html)

[email protected]

run macro error, please help
 
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



All times are GMT +1. The time now is 01:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com