Populating Listbox with autofilter result (should be unique)

below is my code. I have a userform which populates listbox1 on form.initialize event. Let's say I have 100 rows and filtered Column C and yielded 5 results. This means other rows are hidden right? Everything seems fine except that these codes also includes empty cells of the hidden rows. as well as duplicates. any fix for these 2 issues (blanks and duplicates). I just googled these codes so hopefully you can help me without changing all the given codes.

Please Login or Register  to view this content.

Thanks!

Works perfectly! Thanks. Another question, what if i want to show 2 columns c and d (primary filter is still c) ? Which part of the code should i modify? Thanks!