valueof=0

Hi I am looking to add a constraint where the output is within a range of -0.1 and +0.1. I have the following code set up which satisfies the +0.1 constraint. Is there a way to impose the second constraint to define the range? Thanks SolverOk SetCell:="$B$94", MaxMinVal:=2, ValueOf:=0...

Hi I am trying to automate a solver procedure and have the following code: The iteration procedure is working - moving the constraint from R15 to 16....etc as planned However the procedure seems to be loosing the second constraint of Cell K27 =1 Any advice appreciated! Thanks Sub RunSolver()...

Hi there, I'm new the forum so I apologize if the code below doesn't make sense. I would like the variable cell to be ascending Sub year1() ' ' year1 Macro ' ' SolverOk SetCell:="$P$36", MaxMinVal:=3, ValueOf:=0, ByChange:="$B$6:$B$16", _ Engine:=1, EngineDesc:="GRG...

Hello. I have a workbook that contains several sheets. I'm trying to make two solvers run on separate sheets, solver 2 is dependant on solver 1. Solver 1 works as it should but I can't get solver 2 to run by itself, I have inserted a button for solver 2 to work but I would like to run it...