Automatic use of Solver in an Excel model

J

Jasper

Hello everybody,

I'm building a model for my study in Excel with the use of solver. M
question about the use of solver is:

Can solver automatic solve if I change something in the model? So tha
I don't have to go threw the whole proces of solver manually eac
time.

This would save me a lot of time, because I have to change a lot o
things in the model for my results.

Thanks Jaspe
 
J

Jon Peltier

Here are my two favorite programming tools (the secret's out!):

1. Use the Macro Recorder while you manually carry out a Solver solution.
2. Google for VBA Solver

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 

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

"DoEvents"-type behavior in Solver? 1
Use of constant instead of variable in VBA Solver 1
Word VBA - Automatic change content of a cell in table using dropdown list 5
Copying Solver results of each iteration to a given location in a workbook 1
Repeated calls to Solver.xla causing Excel problems 0
Using Solver in VBA for excel without cell references 1
solver add in / excel solver / vba 8
Solver add-in Excel 2000 An unexpected internal error occurred 0

Top