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