VBA search error

[nemisius]

Hi,

This code is ok for a search with 800 rows in a sheet in excel. But if the database grown to 2000 rows, it doesn't work

Can you help me ?

Problem with the cache capacity ?

Thanks

Please Login or Register  to view this content.

[Norie]

How does it not work?

By the way, I doubt very much is anything to do with cache/memory.

[scottiex]

Is the range "Liste" big enough? maybe it is between 2000 and 800 rows.

[bakerman2]

Also AddItem is probably the worst method to use when filling a listbox with that kind of range.
I would recommend using either Advanced Filter or Filter in Listbox.
If possible post example file so we have something to work with.

[jaslake]

Hi nemisius

Welcome to the Forum!!!

I'd assume from your posted Code Range Liste is a Named Range. I'd assume further that it's not Dynamic such that it grows as you add items to the Named Range.

If my assumption is correct try redefining your Named Range Liste to something like this...

With Header...

Please Login or Register  to view this content.

Without Header...

Please Login or Register  to view this content.