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.
Thanks!Please Login or Register to view this content.
Bookmarks