Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looping a solver
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looping a solver
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Looping | Excel Discussion (Misc queries) | |||
Not Looping | Excel Discussion (Misc queries) | |||
Looping | Excel Discussion (Misc queries) | |||
Interesting Solver problem (Solver encounters an error) | Excel Discussion (Misc queries) | |||
Need Looping Help | Excel Programming |