beemer
Civil/Environmental
- May 17, 2003
- 1
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?