Macro for Solver
I wrote a macro in VBA for running solver. The problem is
that each time I run it, the Solver window in Excel is saving the constraints (adding again the arguments in the constraint window). I think I need to add an argument in order to Reset all the solver parameters before setting the target, changing, and constraint arguments. Any help on that? Thanks in advance Velero |
Macro for Solver
Is this what you are looking for?
SolverReset SolverOk _ SetCell:=Range("G14"), _ MaxMinVal:=1, _ ByChange:=Range("G9:I9") -- Dana DeLouis Using Windows XP & Office XP = = = = = = = = = = = = = = = = = "Velero" wrote in message ... I wrote a macro in VBA for running solver. The problem is that each time I run it, the Solver window in Excel is saving the constraints (adding again the arguments in the constraint window). I think I need to add an argument in order to Reset all the solver parameters before setting the target, changing, and constraint arguments. Any help on that? Thanks in advance Velero |
Macro for Solver
Yes. This was, exactly Thank you very much!!!!!! Velero -----Original Message----- Is this what you are looking for? SolverReset SolverOk _ SetCell:=Range("G14"), _ MaxMinVal:=1, _ ByChange:=Range("G9:I9") -- Dana DeLouis Using Windows XP & Office XP = = = = = = = = = = = = = = = = = "Velero" wrote in message ... I wrote a macro in VBA for running solver. The problem is that each time I run it, the Solver window in Excel is saving the constraints (adding again the arguments in the constraint window). I think I need to add an argument in order to Reset all the solver parameters before setting the target, changing, and constraint arguments. Any help on that? Thanks in advance Velero . |
All times are GMT +1. The time now is 09:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com