Automatic use of Solver in an Excel model

Hello everybody,

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

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

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

Thanks Jasper

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/
_______

"Jasper" <[email protected]> wrote in
message news:[email protected]...
>
> Hello everybody,
>
> I'm building a model for my study in Excel with the use of solver. My
> question about the use of solver is:
>
> Can solver automatic solve if I change something in the model? So that
> I don't have to go threw the whole proces of solver manually each
> time.
>
> This would save me a lot of time, because I have to change a lot of
> things in the model for my results.
>
> Thanks Jasper
>
>
> --
> Jasper
> ------------------------------------------------------------------------
> Jasper's Profile:
> http://www.excelforum.com/member.php...o&userid=34292
> View this thread: http://www.excelforum.com/showthread...hreadid=540605
>