Code for automatically resuming after a message box.

Hi all,

I have a piece of code wich uses the Solver in excel. Occasionally I get a message box poping up which says something like "Maximum number of iterations reached". The default option being to proceed regardless, and this is the option I will always use.

Is there code to automatically select this option when it pops up, or to supress the message altogether?

Thanks

ps. increasing the default number of max iterations is not a prefered solution in this case.

Do you mean put

Please Login or Register  to view this content.

before calling the solver?

If so this does not work. I also tried

Please Login or Register  to view this content.

which also does not work

Still no good

Originally Posted by shg

How about increasing the max number of iterations?

This is the obvious fix. Not great, because it's still limited by an arbitary value... suppose I'll just make it really, really big.

I was trying to avoid this but guess I'll just have to bite the bullet.

Thanks Shg