it seems to give me a different answer from the answer i obtained when i click on Solver manually.
If I assume that the values in sheet “MeanVar_MP” cells H5:J5 and I18 are the result of a solver run in your uploaded file so I would expect these values to stay the same if I did a manually rerun of solver.

But a rerun of solver changes range H5:J5 from “0.28862, 0.3577494, 0.353634”
to “0.361779, 0.638221, 0”

And I18 goes from “0.1340433” to “0.207819” and these results are the same as I get when I’m running the macro.

A solver solution may differ depending on the solver “starting point” and looking at you model I see that you have not ticked the box “Use Multistart”. Don’t know if this something you should test I’ll add a link explaining the workings of this then you can decide.

http://www.solver.com/content/basic-...al-solution-17

As for looping solver I assume you wish to update range “O4:V??” with solver results but I can’t see how you change solver settings to get different results.

As an example of setting up a solver loop I'll add this link.

http://www.excelforum.com/excel-prog...ml#post3205531

Alf