View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul Paul is offline
external usenet poster
 
Posts: 661
Default VBA SolverOK not inputting all values into Solver...

I am using VBA to invoke and configure Solver, but all of the information is
not being inserted by the SolverOK VBA command:

SolverOk SetCell:="$B$53", MaxMinVal:=3, ValueOf:="25",
ByChange:="$B$46:$B$51"

The value for the Set target cell field is to be $B$53 and the By changing
values field to be $B46:$B51. The value of 25 is inserted and the correct
logic is set (MaxMinVal;=3), which equates the target cell ($B$53) with the
value of 25. The balance of the code (constraints and options) works OK.

Why are the SetCell and ByChange values not making it into Solver using VBA
SolverOK?