Thank you Dana, you are right, but I only needed the cases for "did not find
optimal solution" (5) anyhow. Thanks again,
Max

"Dana DeLouis" wrote:

I could help myself with:
http://www.frontsys.com/123/lts00104.htm

Just note that your link is for Lotus 123. Excel uses True/False instead of
1/0.
I don't believe return code 14 is used in Excel, but don't hold me to it.
--
Dana DeLouis

"Max" wrote in message
...
I could help myself with:
http://www.frontsys.com/123/lts00104.htm

"Max" wrote:

Hi,

I have written a macro that runs Solver over a dataset and let VB create
messages etc with the outcomes of solver.
However, when Solver could not find a feasible solution, can I relate an
action to this as well? For instance by creating a new value for a cell
in
the worksheet?(or create a messagebox for instance)

Thanks, you would help me a lot with this!
Max