Scripting.Dictionary Question
So I have this code which uses the dictionary object to find unique values in column F. Some of the code was pieced together from internet examples and my current knowledge. I understand how it works except for this line.. What does the "= 1" do? Does it matter what that is set to? Any information is appreciated. Below is the full code:
Please Login or Register to view this content.
Please Login or Register to view this content.
Hello msolari,
It is assigning the value 1 to the Dictionary key represented by CStr(Range("F" & z))).
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Thanks Leith. What does that mean in the grand scheme of things? Can you conjure that list of values with something like this then?Please Login or Register to view this content.
Hello msolari,
If you want to return an array of either all Keys or Items in the Dictionary, you can do so like this...
These arrays are 1-D zero based arrays. The first element subscript is zero, i.e. Keys(0).Please Login or Register to view this content.
Ok..kind of understanding here. Sorry I'm new to the dictionary thing. How would you debug.print a single key? Also, can a single key hold multiple strings?
You can write like that only if you set the reference to "Microsoft Scripting Runtime".Originally Posted by msolari
Please Login or Register to view this content.
e.g
Please Login or Register to view this content.
Thanks jindon, that is enlightening. And answers a few questions for me. But I still have my original questionWhat does the "= 1" do? I realize it sets its value to one but what does that let you do? Does it need to be there? Does it matter even what that is set to? Could I have it set toPlease Login or Register to view this content.Thanks in advancePlease Login or Register to view this content.
it just needs to be a value; it doesn't matter what the value is
Josie
if at first you don't succeed try doing it the way your wife told you to
So the value at the end does not affect the data stored in the dictionary? It doesn't matter at all what that is set to?
Using code from jindon, I realize now that the "=1" sets the item number for that particular key. Thanks. Makes so much sense now.
Let's assume the value of CStr(Range("F" & z)) = "x"DXNRY(CStr(Range("F" & z))) = 1
The line is setting Item property of dictionary for "x" to 1
In other words, it is equivalent to
It is not an Index, so 1 could be anything.Please Login or Register to view this content.
THANK YOU THANK YOU THANK YOU!!! You confirmed it. Been staring at this forever. Such a relief
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks