Solver

Hi Morgan

Thank you for your question

First you need to switch on the solver reference. Click on tools, references and select solver.

There are a number of functions available

SolverOptions allows you to specify the basic parameters of the problem, e.g whether you are maximising or minimising

SolverAdd adds a constraint

SolverSolve seeks a solution

SolverChange changes an existing constraint

I suggest typing solver into the VB help function. There are detailed descriptions of the function arguments together with examples of their use

Regards

Stephen