engine=1

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 all, I'm currently working on my thesis, i have about 2 weeks left before i have to hand it in. The problem lays within my macros. I have 5 macros in my sheet, when i protect the sheets, they stop working, all except 1 which is a simple print macro. I will post the macro text here, if you...