solver in macro

[kristofvdz]

I want to make a macro that uses the excel solver, is this possible? and if its possible how do you do it, i always keep getting errors.

[ This Message was edited by: kristofvdz on 2002-03-28 14:55 ]

[Joe Was]

You do the equivalent of Tools-Solver with the VBA clip:

SolverOK setCell:=Range("AA6"),maxMinVal:=1, byChange:=Range("B8:C11")

Where the trick is "SolverOK" which is the same as Tools-Solver. Note: you need to set the options and you will need additional Solver methods and properties.

The Solver.xla must be installed for these codes to work. JSW