The RemoveAll method removes all key, item pairs from a Dictionary object.
The object is always the name of a Dictionary object.
The following code illustrates use of the RemoveAll method.
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.RemoveAll 'Clear the dictionary
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.