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?
SolverOk SetCell:="$B$94", MaxMinVal:=2, ValueOf:=0...
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!
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
' year1 Macro
SolverOk SetCell:="$P$36", MaxMinVal:=3, ValueOf:=0, ByChange:="$B$6:$B$16", _
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...