Auto Filter Question

T

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
 
A

Alan Beban

theboatdude said:
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
Click to expand...
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
 
Top