Count property (VBA)
This example uses the Collection object's Count property to specify how many iterations are required to remove all the elements of the collection called
MyClasses. When collections are numerically indexed, the base is 1 by default. Because collections are reindexed automatically when a removal is made, the following code removes the first member on each iteration.
Dim Num, MyClasses For Num = 1 To MyClasses.Count ' Remove name from the collection. MyClasses.Remove 1 ' Default collection numeric indexes Next ' begin at 1.
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.