Is a ScriptingDictionary like a named range in that it persists

[Osprey2]

I am using this code ;-

Please Login or Register  to view this content.

To find items in one range that are not in another.
It works fine on the first time of use but on the second gives an error
"This key is already associated with an element of this collection" at the line CodeList.Add Val, I

Using Scripting.Dictionary is such a neat way of getting a list of missing items that I want to hold on to it.
The error message hints that I should get rid of it at the end of this sub so the code creates it fresh again.
Or have I misunderstood what Scripting.Dictionary means.
John

[jindon]

You can only add UNIQUE value to the key, so when you try to add the key that is already exist, it throw the error.

Please Login or Register  to view this content.

[Osprey2]

jindon
Many thanks for your help. I have been able to solve my problem now
John