Dim cnt As Long
Dim i As Long
For i = 0 To List1.ListCount - 1
If Trim(List1.List(i)) <> "" Then cnt = cnt + 1
Next
' cnt will return how many non-blank items; we'll just print for reference. Do what you need here.
Debug.Print "Non-Blank Entries: " & CStr(cnt)
Comment