View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mcglynn mcglynn is offline
external usenet poster
 
Posts: 1
Default 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