Describe what you're doing. I've found that I can generally set up anything
in a hidden worksheet, and avoid the fancier standalone Solvers.

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


"jerome drean" wrote in message
...
as some may know you can use the excel solver from vba - i wonder if it is
possible to use the solver from vba without interacting with the worksheet
object / range - ie i dont see why we cannot access the functionalities of
the solver by giving him an optimisation problem using a function defined
in
vba
this comment could be applicable to many other cases such as graphs for
example

i hope i make sense to some of you