Filtering an array - error when there is no longer a match in the array

[nigelog]

A userform for checking phone numbers displays the possible matches in a listbox. Unlike the filtered range I was using before this method doesn't clear the listbox when there is no longer a match but errors leaving the last matches in the listbox.

Is there a way to catch this error? I assume its because the nwnumlst array is empty when there is no longer a match.
Any help appreciated

Please Login or Register  to view this content.

[rorya]

If there aren't any matches, ii will be 0 so you can just test for that before doing anything else.

[nigelog]

Thanks Rory

Please Login or Register  to view this content.

does what is required

[rorya]

LB_00.Clear would be simpler.

[nigelog]

I tried that first Rory but it did not affect listbox for some reason, Ill try again
Edit: I had

Please Login or Register  to view this content.