user2491612
Reputation:
Last key of a Dictionary Excel VBA
How do I do if I just want the last (inserted) key of a dictionary in excel-VBA?
Will I have to iterate all over the dict every time?
Upvotes: 1
Views: 4303
Answers (1)
chris neilsen
Reputation: 53126
The .Keys property of a Dictionary is an 0 based array of the keys, in the order added.
To get the last added key, use
Dict.Keys(Dict.Count - 1)
Upvotes: 5
Related Questions
- Last Key in Python Dictionary
- Retrieving Last value of a python dictionary
- Last Used Cell in sheet
- Excel VBA - How do I find the smallest and largest keys in a dictionary
- Retrieve nth key in dictionary VBA
- print dictionary key in new worksheet
- Finding the key corresponding to an item in a dictionary
- Dictionary in Python which keeps the last x accessed keys
- how to find the key in dictionary which holds the last appearance of one value(Python)
- Updating values in excel VBA dictionary