ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Solver (https://www.excelbanter.com/excel-programming/304978-solver.html)

Reza[_2_]

Solver
 
Hello,

I try to use SolverOK in a VBA Sub but when I run the Sub
I recieved the message: "Solver: an unexpected internal
error occured, or avalable memory was exhausted". I am
sure that I son't have memory problem.

I used the macro recorder to do the task that I wanted to
do but when I run the code generated by the macro
recorder still I get the same error message.

It is crucial to me, I appreciate any help

Thank you
Reza

merjet

Solver
 
I try to use SolverOK in a VBA Sub but when I run the Sub
I recieved the message: "Solver: an unexpected internal
error occured, or avalable memory was exhausted".


Try changing commands like "SolverAdd" and
"SolverOk" to "SolvAdd", "SolvOk" etc. This
seems to be a bug introduced with Excel XP.

HTH,
Merjet





All times are GMT +1. The time now is 05:17 AM.

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