-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
solverok
-
P
Solver VBA question - automation
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()...- pdhil87
- Thread
- engine=1 maxminval=2 setcell=$b$32 solverok valueof=0
- Replies: 0
- Forum: Excel Questions
-
S
VBA - Multiple solvers - Same workbook different sheet
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...- StianKvam
- Thread
- enginedesc=grg nonlinear solver solverok valueof=0
- Replies: 0
- Forum: Excel Questions
-
R
Some Macros does not work when sheet is protected
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...- refer94
- Thread
- engine=1 relation=1 relation=3 solveradd solverok
- Replies: 3
- Forum: Excel Questions
