VBA Collections Getting the Item Count of a Collection
Example
The number of items in a Collection can be obtained by calling its .Count function:
Syntax:
.Count()
Sample Usage:
Public Sub Example()
Dim foo As New Collection
With foo
.Add "One"
.Add "Two"
.Add "Three"
.Add "Four"
End With
Debug.Print foo.Count 'Prints 4
End Sub
