Multiple Solver uses automatically

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

Guest

I'd like to use Solver to solve for many cells by changing the cell next to
each target cell. Is this possible or do I have to use solver for each cell
individually?
 
Box815 said:
I'd like to use Solver to solve for many cells by changing the cell next to
each target cell. Is this possible or do I have to use solver for each cell
individually?
Click to expand...
If it is part of the same problem, you can specify any number of cells in
the "by changing cells" field.

If it is part of a separate problem, you would have to set up and solve each
problem individually. It could be automated through VBA code but each
problem would still have to be solved individually.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007: Help creating a macro that will run Solver? 3
Multiple solvers in a single worksheet 1
what does error message "too many adjustable cells" mean in solver 1
how do i run solver statistics 1
Solver not found 1
"DoEvents"-type behavior in Solver? 1
Solver won't open 1
Having Solver Call a macro for each iteration 1

Back
Top