Collection.Count Property |
Microsoft.VisualBasic.Collection
objectvariable .Count
Object variable referring to a Collection object
Returns an Integer containing the number of members in the collection
Collections are 1-based; that is, the index of the first element of a collection is 1. In contrast, arrays are 0-based; the index of the first element of an array is 0.
For i = 1 To colMyCollection.Count Set colSubCollection = colMyCollection.Item(CStr(i)) MsgBox colSubCollection.Item("Name") Set colSubCollection = Nothing Next i
Because collections are 1-based, you can iterate the members of a collection by using index values ranging from 1 to the value of objectvariable .Count .
Collection Class, Collection.Add Method, Collection.Item Method, Collection.Remove Method