Posted to microsoft.public.excel.programming

external usenet poster

Posts: 14

For...Next loop limits

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.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
sum, ave with limits, help pls.	Chris	Excel Discussion (Misc queries)	6	November 3rd 08 12:53 PM
UDF limits	David Thielen	Excel Programming	2	April 7th 08 02:53 AM
Dynamic change of limits in for...next loop	[email protected]	Excel Programming	3	March 13th 07 05:53 PM
Row Limits	jv	Excel Worksheet Functions	1	March 17th 06 04:43 PM
Using UsedRange as limits in a For Each loop but for cells on another sheet ?	tur13o	Excel Programming	2	October 23rd 03 01:18 PM

All times are GMT +1. The time now is 06:51 AM.

About Us

"It's about Microsoft Excel"