![]() SolverAdd CellRef:="$C$40", Relation:=2, FormulaText:=". Range("$C$14").Value = Application.Workbooks("test_model_2.xls").Worksheets("All Models").Cells(i, 2).Value ![]() Here is the full code: Private Sub CommandButton2_Click() Sorry for the long winded question, I appreciate any help I get. Without this constraint the cells do set themselves below 35% for the problems I'm validating against, so I know the optimum solution is below 35%.Īlso I was wondering if there is a way to make sure that a) the cells are optimized in increments of 5%, and that the ending value does not include decimals. ![]() They automatically set themselves at 35% when the idea is for these to be as low as possible. The two levers that are being adjusted must be <= 35%, however when I add the constraint: SolverAdd CellRef:="$C$39", Relation:=2, FormulaText:=".35" I want to do the following for a minimization problem and am having some trouble: I am trying to add some new constraints to my excel VBA solver solution and am getting some odd behavior when I run the code. Learn how to disable or completely uninstall and remove an Excel Add-in from the Add-ins menu.To disable an add-in:1.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |