ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Solver and VBA in the same model (https://www.excelbanter.com/excel-programming/287086-solver-vba-same-model.html)

mcglynn

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