Macro with Solver. An unexpected internal error occurred, or available memory

What happens when you run solver manually. Do you get the same error message?

Alf

No, it works just fine.
But I need the macro to perform solver for many cells, so I thought about recording a macro to help me.

Looking at your code I can't see any target cell nor is there a loop command in it so I would suggest you upload the file + a short description of what you wish for solver to do. This would make it easier trying to help you.

Alf

I don't have target cells. My "goal" is to solve to equations (a system), equal them to zero by changing the value of to other cells, my variables that are part of my restrictions.
In the attached file you can see an example of what I'm trying to accomplish.
The yellow cells contain my equations, and the red cells are my variables.
I think I record the macro properly, if don't please let me know.
example.xlsm

*solve two equations...
* changing the value of two other...

Some good and some bad.

The bad: I get the same error as you when I try to run a macro in both excel 2003 and excel 2007 and I must say I have no idea why this error occures. I can't find any problem with your macro.

The good: Testing this macro with Excel2010 it runs without any problem!

Please Login or Register  to view this content.

This macro starts at row 11 and works its way down to row 263 without any problem so if you have access to excel 2010 try that solver (I tested using GRG Nonlinear)

Alf

Ok, I'll try to get microsoft office 2010 then.
Thank you for the help!

Hope you manage to get office 2010. I'll keep on googleing to see if I can find out why it does not work in excel 2007. Perhaps the formulas are too complex?

Alf

Maybe, but I have to follow a restrict model that didn't allows me to change the formulas.
I'm already downloading the office 2010, so the problem will be solve I hope.

I'm already downloading the office 2010, so the problem will be solve I hope

Well according to my findings it should but solver works in mysterious ways it's miracles to perform!

If it works could you please sign your thread "Solved"

Alf

and finally problem [SOLVED].
thank you very much Alf

Thanks for feedback and glad your problem is solved.

Alf

Ps

To mark your thread solved do the following:
- Go to the first post
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save