Solver working intermittingly...tried some previously posted solut

[Guest]

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

 

[Dana DeLouis]

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.

 

[Guest]

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

 

[Guest]

Hi,

Just wondering if anyone has any suggestions? This problem is not resolved.

Thanks,

 

[Guest]

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!