N
NICK
Before you use the solver within a macro, you must
establish a reference to the Solver add-in.
With a Visual Basic module active, click References on the
Tools menu, and then select the Solver.xla check box under
Available References.
If Solver.xla doesn't appear under Available References,
click Browse and open Solver.xla in the \Office\Library
subfolder.
Cheers
Nick
establish a reference to the Solver add-in.
With a Visual Basic module active, click References on the
Tools menu, and then select the Solver.xla check box under
Available References.
If Solver.xla doesn't appear under Available References,
click Browse and open Solver.xla in the \Office\Library
subfolder.
Cheers
Nick