Solver by itself doesn't run itself when the worksheet changes. You
have to initiate Solver by hand. Also, it is not a good idea...no
scratch that...it is a very bad idea...to run an optimization (which is
what Solver does) through an event procedure such as Worksheet_Change.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005

In article ,
says...
In Excel 97 I need solver to solve for a y= equation. However y changes
depending on values in other cells. How can make solver automatically change
it's answer as what it is solving for changes?