Solver and VBA in the same model
I have written a VBA application for solving a system of linear
equations. I tried to provide and alternative solution by setting up a
"Solver" problem in the same workbook. Solver runs OK and produces a
solution, however, when I try to run it again it simply does not appear.
Nothing. I have tried the input data in a new workbook with no VBA attached
and the solver will run repeatedly. However, if I copy the VBA code in, it
runs only once and I have to close the file and reopen to run a second time.
Any ideas on what may be happening, I can't find anything on the internet
which suggests a conflict between solver and VBA?
Thanks
Brian
|