Adding



oDict.Add key:="Mon", item:=10 
oDict.Add(key:="Tue", item:=20)
oDict.Add("Wed", 30)

The key can be any data type.
The item can be any data type.



Updating Values



Key Property

This property enable you to return the key for a particular item in the dictionary.
An item in a Collection object also has a key, which you can use to retrieve the item, however there is no way to retrieve the key itself.





Adding Excel Ranges


dicFSODictionary.Add 

You don't have to add a Range object, you can add Range.Value to store a 1 dimensional array.



© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited TopPrevNext