How do I write an Excel Macro to run Solver repeatedly?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to run solver 36 times on a worksheet as I have an iterative
process that I need to solve. When I run it on individual cells I get a
proper answer returned but when I try to create a macro that runs solver on
all 36 cells none of the cells seem to update.
 
Tushar-

Thank you so much for your help. I really appreciate all the time you have
put into helping me out. However, when I ran this macro, it ended up
printing the text $I$14 in cell I14, $J$14 in J14, etc for all 36 cells. I
don't know what is going on but something is not working properly. Is it
possible to get solver to function properly in a macro in Excel 2000?
 
Back
Top