I have 2 solver questions, that I cannot resolve
- Sometimes Solver (Even though the Constraint is set to Integer).
Will return a decimal number. Is there a way to prevent this?
- This is Solver VBA issue
In VBA routine that calls Solver, is there any way to stop solver turning back on Status Bar and screen Updating.
Even if BOTH are turned off prior to calling the solver, Solver
itself turns them back on.
Indeed even making changes to the Solver xla add-in, the original code is regenerated the next time Excel is loaded
Anyone got any idea?
Or are we looking at a Feature?