It's possible and I've done it.

What's your first Solver function call? In fact, I don't see any code here
at all.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Jim" wrote in message
...
I have used Solver in VBA to solve optimization problems with good
results.
HOWEVER, when I tried to use it in a Monte Carlo For-Next loop, the
debugger highlights the 1st Solver function call.
So here are my questions:
1) Is it possible to execute Solver in a "For-Next" or other loop?
2) Has anyone tried anything similar?
Thanks,
Jim