I have "Solver" solution on one worksheet of a template
that has 20 worksheets. I would like to have a macro that
would "trigger" the "solver" and accept the solution. The
"solver has 4 constraints (values = 0) and 5 cells that can
be changed. It usually takes 5-10 iterations to generate a
solution. Any ideas?