Auto Filter Question

[theboatdude]

Hello Everyone -

When using auto filter, is there a maximum amount of entries that it
will filter? Case in point, I have a spreadsheet with about 4800
lines, with enties from A to Z; when I select auto filter on a given
column, it seems to list the entries up to, say, the I's (even though I
know that there are entries all the way to Z. What gives? First I
thought that I might have another filter on that was truncating the
data, but that doesn't seem to be the case.

Thankx,

CT

 

[Frank Kabel]

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

 

[Alan Beban]

Hello Everyone -

When using auto filter, is there a maximum amount of entries that it
will filter? Case in point, I have a spreadsheet with about 4800
lines, with enties from A to Z; when I select auto filter on a given
column, it seems to list the entries up to, say, the I's (even though I
know that there are entries all the way to Z. What gives? First I
thought that I might have another filter on that was truncating the
data, but that doesn't seem to be the case.

Thankx,

CT

There is a 1000 record limit. If the functions in the freely
downloadable file at http://home.pacbell.net/beban are available to your
workbook, the following may be of some help, though it's not
particularly fast

outputRange.Value = ArrayRowFilter1(dataRange,FilterColumn,FilterValue)

Alan Beban