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 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...
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...