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 ]
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
Like this thread? Share it with others