Solver

[Reza]

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]

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