Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
 
Posts: n/a
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date macro Hiking Excel Discussion (Misc queries) 9 February 3rd 05 12:40 AM
Help with macro formula and variable Huge project Excel Worksheet Functions 0 December 28th 04 01:27 AM
Macro and If Statement SATB Excel Discussion (Misc queries) 2 December 3rd 04 04:46 PM
Macro Formula revision? Mark Excel Worksheet Functions 1 November 28th 04 01:43 AM
Macro for multiple charts JS Excel Worksheet Functions 1 November 19th 04 03:44 AM


All times are GMT +1. The time now is 10:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"