You can call solver from VBA.

http://support.microsoft.com/support...ver/solver.asp
Creating Visual Basic Macros that Use Microsoft Excel Solver

Regards,
Tom Ogilvy


"Phil" wrote in message
...
I would like to know if it is possible to optimize or
minimize functions with VB.
I know the 'Solver' does it in Excel, but is there a
similar fonction in VB?

Thank you