vba Dictionary - understanding the code

[Mallesh23]

Hi Team,

I am learning VBA Dictionary and trying to understand the below line.
I stuck only with with word Nothing.

Can you someone tell what that Nothing word means.

With Dict
For Each Cl In Sht2.Range("A2:A" & sht2UsdRws)
If Not .exists(Cl.Value) Then .Add Cl.Value, Nothing
Next Cl

Thanks your help in Advance !!


Regards
Mallesh.

 

[Kenneth Hobson]

Re: vba Dictionary - help required in understanding the code

Press F1 with cursor in or next to a command word to get specific help. In this case, think of it as Null, vbNullString, Empty, or "". It means set the value to well, Nothing. This is common practice as one must enter both input parameter values.

The best help for that object is in a file called Script56.chm.

 

[hiker95]

Re: vba Dictionary - help required in understanding the code

Mallesh23,

If you are trying to learn how to use the Scripting.Dictionary, then check out threads by MickG