Is there a max number of loops a For....Next can do?

I have set it to 40000 and it fails with an overflow error, but works
fine for 30000

Thanks.

Sounds like you have Dim the loop counter as Integer rather than Long

Charles
__________________________________________________
The Excel Calculation Site
http://www.decisionmodels.com

"macroapa" wrote in message
...
Is there a max number of loops a For....Next can do?

I have set it to 40000 and it fails with an overflow error, but works
fine for 30000

Thanks.

To get a specific answer to your problem it pays to post a copy of your
code otherwise we can only guess at the cause

Charles Williams reply covers the most common cause of the type of
problem you discribed


--
mudraker

If my reply has assisted or failed to assist you I welcome your
Feedback.

www.thecodecage.com
------------------------------------------------------------------------
mudraker's Profile: http://www.thecodecage.com/forumz/member.php?userid=18
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=37455