Autofilter problem

[ROn...]

Hello,


I have created a huge Excel VBA - application (+/- 3Mb. This
application imports diffent excel workmaps with different data to a
excel workmap with the data in one format.

After this i can use the autofilter to select data.

However, not all the items in the column are shown in the autofilter.
Even in a column with 5 items in a 20000 row worksheet the autofilter
sometimes doesn't show all items.

Is it possible that this is caused by memory limitations of the
computer (at my work, a very old and slow network computer)?

Gr. ROn...

 

[Norman Jones]

Hi ROn,

See Debra Dalgleish's explanation and possible workaround at:

http://www.contextures.com/xlautofilter02.html#Limits

 

[ROn...]

Tnx for your reply. It's nice to know that it's a 'feauture' of Excel
and not caused by my code.

Gr. ROn...

 

[Tom Ogilvy]

Even in a column with 5 items in a 20000 row worksheet the autofilter

Guess that wasn't really a problem then?

 

[ROn...]

Guess that wasn't really a problem then?

Unfortunally (sp?) it's a big problem. I can't fix it with the
suggestions in your link. Now i am programming an option to bypass this
problem (code to find items in the list and then flag it with a letter
in column 1)...

Gr. ROn...