I wrote a a macro that runs solver to solve a very small LP over a 1000 times. the macro works fine for a number of iterations but then an excel error fatal error message pops up. I presume that it has something to do with solver chewing up memory. Any ideas about how I might solve the problem