Hi Larry €“

Unless you need the range named for some other reason, try eliminating the
range name completely (|Insert|Name|Define|[Delete]). The autofilter range
€˜grows automatically when you add data to the bottom of the list (at least
in Excel 2003).

--
Jay


"Larry" wrote:

I have gone to insert/name/define and defined the range to $B:$645536. When I
use the scroll bar to to the right to scroll to the bottom of the page it
only scrolls down to approx 51000. I must have a setting somewhere that is
limiting that but I'm not sure where. When I set my print range to row 51000
I get no blank pages. If I set it to 645536 I get 200 plus blank pages.

"Dave Peterson" wrote:

I've never seen a limit on the number of rows that can be filtered.

But I have seen examples where the range that was filtered wasn't what the user
wanted--and the filtered range was either too large or too small.

I'd guess that your defined name isn't pointing to what you expected. (Maybe
the range got resized after you defined it???)

If you hit F5, then type in that named range, does your range get selected
correctly?

You may want to share how you created the name, what it's currently pointing to
(the address) and how you applied the data|Filter|autofilter.

If you're working with names, get Jan Karel Pieterse's (with Charles Williams
and Matthew Henson) Name Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

It'll make working with names much easier.



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


--

Dave Peterson