LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default maximum number of members in a collection

Hi

I tried to create an Excell2003 VB collection with say 1500-2000 members.
But after 256 members are added, the loop continues WITHOUT ANY ERROR MESSAGE
but no more members are added to the collection

Is it possible that 256 is the limit?

I couldn't find it written down anywhere, but that limit is just too low.

I was just wondering if any of you knows more about this?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Maximum negative number Tigerxxx Excel Discussion (Misc queries) 2 June 15th 09 06:35 PM
Excel maximum Row number xiaoniao Excel Worksheet Functions 2 April 29th 08 02:44 PM
Team Role Rotation (number of team members is variable) Scott Wagner Excel Worksheet Functions 3 November 17th 06 11:25 PM
getting the number of the row with the maximum value hilbert Excel Discussion (Misc queries) 3 April 5th 05 01:06 PM
cell number in collection Chris Gorham[_3_] Excel Programming 1 December 26th 03 10:47 PM


All times are GMT +1. The time now is 07:16 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"