For...Next loop limits

M

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.
 
M

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
 
Top