Solver working intermittingly...tried some previously posted solut
Hi,
I am having issues with Solver -- my code is below. It only works with the code after running it manually -- and only when the same exact scenario being run by the code is executed manually first (if I run Solver manually for a scenario which is completely different than the scenario in the code, the code still does not work). There is no error coming up, it just completes with no output. I tried putting in the statement directly below into my code (saw this suggestion in another post), but this does not correct the issue. Application.Run "Solver.xla!Solver.Solver2.Auto_open" Any idea on how I can resolve this? Thanks ahead of time! ' In the scenario I've been testing, "holdclearsumprod" ='Transaction Summary'! _ $AK$1, cell AK1 = sumproduct(L2:L5,AJ2:AJ5), "holdclearbin" ='Transaction _ Summary'!$AJ$2:$AJ$5 Sheets("Transaction Summary").Activate SolverOk SetCell:="holdclearsumprod", MaxMinVal:=3, ValueOf:="=AL1", _ ByChange:="holdclearbin" SolverAdd CellRef:="holdclearbin", Relation:=5, FormulaText:="binary" SolverSolve userfinish:=True -- Robert |
Solver working intermittingly...tried some previously posted solut
HI. I am only guessing here. You are only changing Binary Cells somewhere,
and eventually they make their way to the Target Cell: ie sumproduct(L2:L5,AJ2:AJ5), Make sure you are not using such functions as IF( ) , ABS(), or Lookup() anywhere in your model. Again, just a guess. -- Dana "robs3131" wrote in message ... Hi, I am having issues with Solver -- my code is below. It only works with the code after running it manually -- and only when the same exact scenario being run by the code is executed manually first (if I run Solver manually for a scenario which is completely different than the scenario in the code, the code still does not work). There is no error coming up, it just completes with no output. I tried putting in the statement directly below into my code (saw this suggestion in another post), but this does not correct the issue. Application.Run "Solver.xla!Solver.Solver2.Auto_open" Any idea on how I can resolve this? Thanks ahead of time! ' In the scenario I've been testing, "holdclearsumprod" ='Transaction Summary'! _ $AK$1, cell AK1 = sumproduct(L2:L5,AJ2:AJ5), "holdclearbin" ='Transaction _ Summary'!$AJ$2:$AJ$5 Sheets("Transaction Summary").Activate SolverOk SetCell:="holdclearsumprod", MaxMinVal:=3, ValueOf:="=AL1", _ ByChange:="holdclearbin" SolverAdd CellRef:="holdclearbin", Relation:=5, FormulaText:="binary" SolverSolve userfinish:=True -- Robert |
Solver working intermittingly...tried some previously posted s
Hi Dana,
I'm not using the functions you listed. Thank for your input though. I still don't know what the issue is. Thanks, Robert -- Robert "Dana DeLouis" wrote: HI. I am only guessing here. You are only changing Binary Cells somewhere, and eventually they make their way to the Target Cell: ie sumproduct(L2:L5,AJ2:AJ5), Make sure you are not using such functions as IF( ) , ABS(), or Lookup() anywhere in your model. Again, just a guess. -- Dana "robs3131" wrote in message ... Hi, I am having issues with Solver -- my code is below. It only works with the code after running it manually -- and only when the same exact scenario being run by the code is executed manually first (if I run Solver manually for a scenario which is completely different than the scenario in the code, the code still does not work). There is no error coming up, it just completes with no output. I tried putting in the statement directly below into my code (saw this suggestion in another post), but this does not correct the issue. Application.Run "Solver.xla!Solver.Solver2.Auto_open" Any idea on how I can resolve this? Thanks ahead of time! ' In the scenario I've been testing, "holdclearsumprod" ='Transaction Summary'! _ $AK$1, cell AK1 = sumproduct(L2:L5,AJ2:AJ5), "holdclearbin" ='Transaction _ Summary'!$AJ$2:$AJ$5 Sheets("Transaction Summary").Activate SolverOk SetCell:="holdclearsumprod", MaxMinVal:=3, ValueOf:="=AL1", _ ByChange:="holdclearbin" SolverAdd CellRef:="holdclearbin", Relation:=5, FormulaText:="binary" SolverSolve userfinish:=True -- Robert |
Solver working intermittingly...tried some previously posted s
Hi,
Just wondering if anyone has any suggestions? This problem is not resolved. Thanks, -- Robert "robs3131" wrote: Hi Dana, I'm not using the functions you listed. Thank for your input though. I still don't know what the issue is. Thanks, Robert -- Robert "Dana DeLouis" wrote: HI. I am only guessing here. You are only changing Binary Cells somewhere, and eventually they make their way to the Target Cell: ie sumproduct(L2:L5,AJ2:AJ5), Make sure you are not using such functions as IF( ) , ABS(), or Lookup() anywhere in your model. Again, just a guess. -- Dana "robs3131" wrote in message ... Hi, I am having issues with Solver -- my code is below. It only works with the code after running it manually -- and only when the same exact scenario being run by the code is executed manually first (if I run Solver manually for a scenario which is completely different than the scenario in the code, the code still does not work). There is no error coming up, it just completes with no output. I tried putting in the statement directly below into my code (saw this suggestion in another post), but this does not correct the issue. Application.Run "Solver.xla!Solver.Solver2.Auto_open" Any idea on how I can resolve this? Thanks ahead of time! ' In the scenario I've been testing, "holdclearsumprod" ='Transaction Summary'! _ $AK$1, cell AK1 = sumproduct(L2:L5,AJ2:AJ5), "holdclearbin" ='Transaction _ Summary'!$AJ$2:$AJ$5 Sheets("Transaction Summary").Activate SolverOk SetCell:="holdclearsumprod", MaxMinVal:=3, ValueOf:="=AL1", _ ByChange:="holdclearbin" SolverAdd CellRef:="holdclearbin", Relation:=5, FormulaText:="binary" SolverSolve userfinish:=True -- Robert |
Solver working intermittingly...tried some previously posted s
Hi all,
I seem to have corrected the problem. FYI - I did the following two things and now it's working: 1 - I used the solution listed under "Preparing Solver for First Use" which is at the bottom of the following web page (Peltier Technical Services) -- specifically, I added the function that was listed here and called it on the "Woorkbook" "Open" event. http://peltiertech.com/Excel/SolverVBA.html 2 - I changed the following in my code listed below: From: ValueOf:="=AL1", To: ValueOf:=Range("AL1").Value, Hope this helps anyone having the same problem! -- Robert "robs3131" wrote: Hi, Just wondering if anyone has any suggestions? This problem is not resolved. Thanks, -- Robert "robs3131" wrote: Hi Dana, I'm not using the functions you listed. Thank for your input though. I still don't know what the issue is. Thanks, Robert -- Robert "Dana DeLouis" wrote: HI. I am only guessing here. You are only changing Binary Cells somewhere, and eventually they make their way to the Target Cell: ie sumproduct(L2:L5,AJ2:AJ5), Make sure you are not using such functions as IF( ) , ABS(), or Lookup() anywhere in your model. Again, just a guess. -- Dana "robs3131" wrote in message ... Hi, I am having issues with Solver -- my code is below. It only works with the code after running it manually -- and only when the same exact scenario being run by the code is executed manually first (if I run Solver manually for a scenario which is completely different than the scenario in the code, the code still does not work). There is no error coming up, it just completes with no output. I tried putting in the statement directly below into my code (saw this suggestion in another post), but this does not correct the issue. Application.Run "Solver.xla!Solver.Solver2.Auto_open" Any idea on how I can resolve this? Thanks ahead of time! ' In the scenario I've been testing, "holdclearsumprod" ='Transaction Summary'! _ $AK$1, cell AK1 = sumproduct(L2:L5,AJ2:AJ5), "holdclearbin" ='Transaction _ Summary'!$AJ$2:$AJ$5 Sheets("Transaction Summary").Activate SolverOk SetCell:="holdclearsumprod", MaxMinVal:=3, ValueOf:="=AL1", _ ByChange:="holdclearbin" SolverAdd CellRef:="holdclearbin", Relation:=5, FormulaText:="binary" SolverSolve userfinish:=True -- Robert |
All times are GMT +1. The time now is 05:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com