Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by SteveGregory
-
Excel 2000 Solver: An unexpected internal error occurred
I tried changing my second version of the macro to find out what instruction was causing Solver to choke. The error occurs when setting the ByChange cell P1X. New VBA macro: Sub Model() SolverReset SolverOk SetCell:="M" SolverOk MaxMinVal:=1 SolverOk ByChange:="P1X"...- SteveGregory
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel 2000 Solver: An unexpected internal error occurred
An unexpected internal error occurred, or available memory was exhausted." I've tried a hotfix download from Microsoft. I've tried the 'Application.Run "Solver.xla!MenuUpdate"', the 'Application.Run "Solver.xla!Auto_Open"'. Then, I tried only loading the parameters that I really needed and the...- SteveGregory
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
