Hi Larry -

I'm not aware of any record limitation on the autofilter. Ive never
experienced the problem you describe when dealing with large numbers of
records. It's been a pretty stable and predictable tool.

Without seeing the file, I dont know if I have an answer for your latest
post. If you would like, you can email it to and
Ill take a look. I cant speak for Dave, but Im guessing that he would be
interested, too, if he accepts emailed files (some people prefer not to due
to virus concerns).

I keep hitting dead ends when analyzing your problem, hence the request to
see the file. As Dave suggested earlier, filtering for non-blanks should do
the trick, so I cant explain the behavior.

Also, let us know what version of excel you are using.

--
Jay


"Larry" wrote:

I have created a named range to include the columns I want all the way to row
65536. I have used that range to create an auto filter. When I filter for
non blanks It hides all the rows with blanks in that column all the way up to
row 51127. The blank rows from 51128 through 65536 are not filtered out. Is
there a limit to the number of rows auto filter works on.

"Dave Peterson" wrote:

If you can pick out a column that is only empty when the row isn't used, maybe
you can just apply Data|Filter|autofilter to that column.

Then filter to show the nonblanks and print that.

Larry wrote:

I have a database that continues to grow in rows. I am trying to print only
the data and not the blank lines. I have tried to make a range that includes
all of the lines to the bottom of the sheet and then filter out the blank
lines. This works to a degree but it only works to about 51000 lines and
then the blank pages start to appear again. need help

--

Dave Peterson