How to save SOLVER iterations in Excel cells (VBA)

[Juggler_IN]

When we run solver, we get the final (optimum) solution. While sover is running, it calculates the values for multiple points and settles on the optimum one. Is there a way to save all the values that solver tries to a range in the excel sheet, along with the optimum solution.

Thanks.

 

[Oaktree]

I don't believe so, no... but, I am curious why you'd be interested in those. Are you trying to reverse engineer the Simplex Algorithm?

 

[Juggler_IN]

Not really trying to reverse engineer, but just wanted to capture and see the evaluated options before the optimal solution is reached.