Using a variable in solver

[Guest]

I am tring to use a macro so that a user can input a number into a call and
when the macro is run the solver references that cell.(e25 in this case.)
When I run the code it seems to default to the current settings in the solver
and not the referenced cell. I have tried resetting the values on the
solver. Anyone have any thoughts. Here is the code I am using:

SolverOk SetCell:="$B$25", MaxMinVal:=0.01, _
ValueOf:=Range("$e$25").Value, _
ByChange:="$B$22"
SolverSolve

Thanks.

Stephen

 

[Dana DeLouis]

SolverOk SetCell:="$B$25", MaxMinVal:=0.01, _

ValueOf:=Range("$e$25").Value, _
ByChange:="$B$22"

Hello. In your above code, "MaxMinVal" indicates what type of operation to
perform. If should not be set to 0.01 (just 1,2, or 3). See if using
MaxMinVal:=3 will work since you are trying to set B25 to a specific value .

 

[Guest]

THANKS! It works perfectly know.