Hi,
I am using Solver for an optimization problem, but I need to run a VBA subroutine at each intermediate step in order to correctly calculate the objective function. As near as I can tell from Google searches, I probably need the following lines:
SolverOptions StepThru:=True
SolverSolve UserFinish:=True, ShowRef:="subroutine_name_goes_here"
In the above line the subroutine name is actually between " ". But I think the syntax for the SolverSolve line above is wrong. From a Google search is seems that many have had the same question but cannot really find a lucid answer.
Note that I am using VBA code to set the solver parameters and then call Solver.
Bookmarks