Find the size of a dictionary object in VBA

Question

What is the easiest way in VBA to determine the size (i.e. the number of keys) in a dictionary object?

+5

Gershwyn Apr 15 '10 at 15:20

2 answers

For the number of keys (not elements) you should use the property .Keys, through UBound(Dictionary.Keys), since its array

+3

Z. Khullah Sep 26 '16 at 21:57

Alex K. · Accepted Answer · 2010-04-15T15:27:28+0000

Like in Scripting.Dictionary? just use the property .Count.