Userform:Search through all ws / show results in Listbox

Hi wali
I've downloaded your zip file. The procedure halts when it gets to row 8270 of Sheet 1. The data in A8270 is bad data (#NAME?). If you figure out what's causing the bad data, the procedure should run fine.

The procedure probably could be modified to skip these invalid items. Let me know how you wish to proceed.

PS: after seeing your file, I see I totally misunderstood what you were saying. I apologize.