Returns a Long (long integer) containing the number of items in a collection or Dictionary object. Read-only.
The object is always the name of one of the items in the Applies To list.
The following code illustrates use of the Count property.
Dim a, d, i 'Create some variables Set d = CreateObject("Scripting.Dictionary") d.Add "a", "Athens" 'Add some keys and items. d.Add "b", "Belgrade" d.Add "c", "Cairo" a = d.Keys 'Get the keys For i = 0 To d.Count -1 'Iterate the array Print a(i) 'Print key Next ...
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.