For...Next loop limits

[macroapa]

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.

 

[Charles Williams]

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

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

 

[mudraker]

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