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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula-Find Duplicates 3
Overflow error when using FOR loop 2
problem with replace command 5
variable number of For Next loops 3
for next loop question 3
Automatically Save 1
Dynamic change of limits in for...next loop 3
Six columns randon no.'s no dupes 6

Top