How do I save a solver solution in VBA
 

I would like to run a solver solution to calculate a certain scenario via a
macro; how do i get the solution saved to a cell independent of the original
cell to be changed?

Appreciate any pointers there.

thanks
george