Read Range To Array, Then Pass Array To Function

Dear All,

I'm trying to write some code to do a fancy series of searches, but before I can do that, I need to create a list of unique elements (ie get rid of duplicates). I used an example I found somewhere to write my own function that does the job, and works fine for arrays defined item by item in excel vba.

Please Login or Register  to view this content.

This works fine on arrays that are defined via excel vba enumerating each element. However, if I try to pass an array I created by reading in from a range of values it gives me a "subscript out of range" error. If I try to redim the range it also gets angry, although for different reasons. What is the right way to do this? My attempt is below.

Please Login or Register  to view this content.

The data of interest is just a bunch of numbers (that I treat as strings really) that are all 9 digits long. Thanks much for your help.

Thanks all. It turns out DonkeyOte was right, it was a problem with dimensions. I used transpose to make it a 1D array, made sure the indicies were alright and I was good to go. It works just like I want it to now.