vba 2010 excel.
I have a listbox.
That contains blanks items in the listbox
The code below will help get rids of dups in the listbox.
But I need to just get rid of all blanks or null values from a listbox.
I believe i just check for
If .List(z) = "" and/or If .List(f) = ""
But trying to figure out how to nest it here in the code ?
For f = 0 To .ListCount - 1
For z = .ListCount To (f + 1) Step -1
If .List(z) = .List(f) Then