Macro to write dictionary keys to array not working

**capson** · 11-07-2015, 05:12 PM

I am trying to use a dictionary to create array of unique items from a column range

The column cells are text (titles)

I know very little about dictionaries, trying to learn something new

I get an array filled with 1's

Thanks

Please Login or Register  to view this content.

**capson** · 11-07-2015, 05:15 PM

As soon as I posted I figured it out:

Please Login or Register  to view this content.

>>

Please Login or Register  to view this content.

**YasserKhalil** · 11-07-2015, 05:21 PM

Hi capson
fix this part

Please Login or Register  to view this content.

Macro to write dictionary keys to array not working

LinkBack

Thread Tools

Rate This Thread

Display

Macro to write dictionary keys to array not working

Re: Macro to write dictionary keys to array not working

Re: Macro to write dictionary keys to array not working

Thread Information

Users Browsing this Thread

Similar Threads

Keyboard keys are not working after running macro

[SOLVED] Filter data using keys in dictionary

help assigning elements of dictionary to array and then pasting array into worksheet

[SOLVED] Transposing dictionary keys and items into one column

[SOLVED] Problems retrieving keys as well as items when using scripting dictionary

Get multiple user selected cell range addresses and write to dictionary

Read Registry Keys (and possibly write)

Bookmarks

Bookmarks

Posting Permissions