Hey all!

I'am trying to add only unique values to a combobox in a userform. I've been using this code.

Please Login or Register  to view this content.
Problem is, that it only adds a one of the hundred numbers, and it changes all the time. If i remove COUNTIF it adds all the values in the range, duplicates or not. What am I doing wrong?