SolverOK setCell and byChange args are not passed to the solver

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using the Solver functions from a VB macro the SolverOK or solverOKDialog
never accepts the arguments SetCell and ByChange. No error report just that
no value is entered for the corresponing values. I've tried several different
formats, including those suggested in the help function. I can run the solver
in normal interactive mode but not from code, passing the same values. The
maxminVal and ValueOf parameters enter ok. I use A1 notation in the sheet and
pass the references in the same format. What could be wrong. It seems like a
bug. I use Excel 2000 (9.06926 SP-3)
 
If you'd posted your code, someone could have seen whether the order of
commands was a problem.

- Jon
 

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 marco still prompts to keep solution 1
Another solver question 1
Solver Macro in Excel 2007 1
Issue with Solver in Macro 0
VBA code to RUN Solver mutiple times (on different target cells) 8
VBA not adding elements to Solver model 0
Adding multiple solver conditions in VBA 0

Back
Top