How do i retrieve the items in my scriptiing Dictionary and Assign them to a variable?

**Darthzo** · 01-10-2014, 03:25 PM

I have an array that was created I need to only use unique values from the array and assign them to a variable. Below is the code I am using for this at the very end I am having issues assigning the item to the variable(I am new to dictionary in general so this a learning curve I am dealing with). Thank You.

Please Login or Register  to view this content.

**Kenneth Hobson** · 01-10-2014, 04:58 PM

Obviously, Join returns a string which is used in the MsgBox

Please Login or Register  to view this content.

**Darthzo** · 01-13-2014, 12:19 PM

Thank you Kenneth that seems to work out. I will keep the "Join" in mind for future issues.

**Kenneth Hobson** · 01-13-2014, 12:46 PM

If you need to sort the data, this thread shows how to do both. http://www.excelforum.com/excel-prog...cal-order.html

How do i retrieve the items in my scriptiing Dictionary and Assign them to a variable?

LinkBack

Thread Tools

Rate This Thread

Display

How do i retrieve the items in my scriptiing Dictionary and Assign them to a variable?

Re: How do i retrieve the items in my scriptiing Dictionary and Assign them to a variable?

Re: How do i retrieve the items in my scriptiing Dictionary and Assign them to a variable?

Re: How do i retrieve the items in my scriptiing Dictionary and Assign them to a variable?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Adding items to Dictionary object

[SOLVED] retrieve child items from visible pivot items.

[SOLVED] Scripting Dictionary add additional items

Nested dictionary items, how do you access them?

looping through items in a dictionary

Bookmarks

Bookmarks

Posting Permissions