Solver - VBA not running

[Mariner191]

Mr. Excel,

Attempting to run macro to automate a Solver.
Code errors out on the first appearance of "SolverOk"
SolverOk SetCell:="$U$6",

Error message indicates "Compile Error: Sub or Function not defined".
Please advise.

Thank you in advance,
Mariner191

 

[Colin Legg]

Hi,

First, make sure that the Solver add-in is installed (in the main Excel interface go via Tools | Add-Ins).
Next, in the VBE go to Tools | References and tick the SOLVER reference.

For more information see here:
http://peltiertech.com/Excel/SolverVBA.html


Hope that helps...

 

[Mariner191]

Colin_L,

Your solution was on target.
1. VBE go to Tools | References and tick the SOLVER reference
2. Start the code with SolverReset
3. End the code with SolverSolve True

Thank you!
Mariner191