Listbox referring to hidden range

[bibu]

I have this code for a texbox to search into a listbox
It's working properly but sometimes it doesn't look at all the names in the list.. probably because some of the rows are hidden?

Please Login or Register  to view this content.

I think the solution will be for the Rows.Count to also look at hidden rows.
Or I can try to move the name list to another sheet and make the code refer to that, but I could not find the proper way to make it look at Sheets("Sheet2") and AC column, for example.
Thanks for your time.

[BigBas]

Hidden cells should be included in the array, and would therefore be included in the listbox... Unless they are the last rows in the data range. One workaround is to change the below code:

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Let me know if that works

[bibu]

Actually I have found a kind of fix, in listboxt properties, if I set TopIndex to 1, everything is fine and dandy.
I have tried including ListBox1.TopIndex = 1 into the code but it gives an error.
And still the problem is that the setting isnt' saved.. I have to set Topindex to 1 everytime I open the sheet.
I will try what you suggested thanks!

[bibu]

BigBas - it seems to be working, thanks and + rep!

[BigBas]

Not a problem. And thanks for the + rep!