Looping a solver

[Aaron Frick]

I have written a solver macro, but since the problem is
non linear it won't find the optimal solution unless I
run the macro 5 or 6 times. Can I have the macro
automatically run the solver n times?

Thank you for your help?

 

[RWN]

Not really sure what you're doing but typically in these situations you'd
have it perform its iterations until some degree of precision is satisfied.

Something like;
Do Until <whatever your desired degree of precision is>
<Your routine>
Loop

You'd have to ensure that the precision can be found (or it'll go forever!).

If it's simply a case of having the routine execute n times then
For i = 1 to n
<Your Routine>
Next


--
Regards;
Rob

Please reply to the NG, I'm already up to my eyeballs in Nigerian/South
African get rich letters
as well as "Microsoft Critical Updates" et al.