Speeding Up Unique Value List Function

Hi all,

Long time visitor, first time poster. I was able to create this following Frankenstein function that will take in an array or range and pick out the unique values, then enter them into a comma separated list. I created it from various UDFs I've seen on this site and elsewhere. This function needs to be able to take arrays, not just ranges, as I use the IF function extensively within the UDF.

The problem I am having with this is that running this function about 2000 times will take over an hour to run. I don't believe the code is properly optimized and would appreciate any help from some of the VBA experts on this site. Let me know if I can provide any more details that might be helpful.

Thanks.

Please Login or Register  to view this content.

Is this how you wanted?

Please Login or Register  to view this content.

Thanks a lot. Both of these are improvements on what I was using. jindon's solution was better, as it took 10 minutes to run for the entire sheet, and the VBA code is just so simple.