G Guest Nov 12, 2003 #1 Hi. Is it possible to create a macro which involves using solver? I tried, but got an error.
N NICK Nov 13, 2003 #2 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 -----Original Message----- Hi. Is it possible to create a macro which involves Click to expand... using solver? I tried, but got an error.
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 -----Original Message----- Hi. Is it possible to create a macro which involves Click to expand... using solver? I tried, but got an error.
