Problems assigning value to an array: Run-Time error 9

[nai0248]

Code is below:

Trying to read the value of a cell to put only unique values into an array for later uses.

Please Login or Register  to view this content.

[Sadath31]

You can use this to remove duplicates

Please Login or Register  to view this content.

[nai0248]

Thanks a bunch. The first part (collection) is what I needed for now. Now to just figure out the remaining part...

[nai0248]

I'm a bit confused why adding to a collection does not include duplicates but adding to an array does. I could not locate anything in the syntax description that states a collection would not include duplicates.

[shg]

A collection does not allow entries with duplicate keys; it generates a run-time error, and does not add the item.

The On Error Resume Next statement suppresses the error.

[snb]

Unique values in column A to array sq

Please Login or Register  to view this content.