lenght of scripting dictionary

[Forestq]

hi,

I'm using Scripting Dictionary to make unique list:

 Dim count_result As Long
 count_result = 0
 Set dict = CreateObject("Scripting.Dictionary")

For i = 3 To last_row
        looking_string = wsC.Range("O" + CStr(i)).Value
            
                If Not dict.exists(looking_string) Then
                    dict.Add looking_string, ""
                End If
                
            End If
 Next i

Now I want to know how many items I have in dict. How to count lenght of dict?

 

[Norie]

Use the Count property of the dictionary?

 

[Forestq]

below doesn`t work:

dict_result = dict.lenght

 

[Norie]

The property is called Count not length.

 

[Forestq]

ahh thanks!