Dear all,
another issue with solver. I have a certain Macro generating the ByChangeValues string to tell solver which values he might modify. For simple problem this works fine. But in cas more than approx. 30 Values are fed in, Solver does not accept the input and the field remains empty and he so does nothing at all.
The official limits are 200 or so which I do not use. If I manually fill in 100 values everything runs without any problems.
The string itself does not cause the problem. (saying it looks just as it should in the debugger mode)
Any ideas?
Thanks Axel
SolverOk SetCell:="$J$25", MaxMinVal:=2, ValueOf:="0", ByChange:=ByChangeValues
another issue with solver. I have a certain Macro generating the ByChangeValues string to tell solver which values he might modify. For simple problem this works fine. But in cas more than approx. 30 Values are fed in, Solver does not accept the input and the field remains empty and he so does nothing at all.
The official limits are 200 or so which I do not use. If I manually fill in 100 values everything runs without any problems.
The string itself does not cause the problem. (saying it looks just as it should in the debugger mode)
Any ideas?
Thanks Axel
SolverOk SetCell:="$J$25", MaxMinVal:=2, ValueOf:="0", ByChange:=ByChangeValues