![]() |
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 |
All times are GMT +1. The time now is 10:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com