How can I run solver add-in in a macro?

G

Guest

Excel-2000 macro does not run solver even if solver is add-in is recognized
as a reference in the code? The code is as below:

SolverOk SetCell:="$j$11", MaxMinVal:=2, ValueOf:="0", ByChange:="$e$7"
SolverSolve (True)

Thanks in advance for your help...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Solver iteration in VBA macro 2
Solver Problem 1
Solver marco still prompts to keep solution 1
Solver Macro in Excel 2007 1
Another solver question 1
VBA code to RUN Solver mutiple times (on different target cells) 8
Issue with Solver in Macro 0
Solver 1

Top