Richard,

having done that, you could now highlight row 2076 (the blank row) and
Edit | Delete to remove it. That should reset your filter range so that
you do not get "Blanks" listed in the drop-down.

I suspect that you might have two cells somewhere that are merged
together - Excel thinks that there are only 2074 cells (and therefore
rows) in the filter range.

Hope this helps.

Pete

Richard wrote:
Bill,
Adjusting the print area didn't help.
However, when I selected all the data plus one blank row, it did include the
'real' last row (2075) in the filtering. Only problem is that it now as a
filter option listed as 'blanks' - which is not too bad of a problem.
--
Richard


"Bill Ridgeway" wrote:

Richard,

I have also seen a similar problem where the spreadsheet will sort all bar
the last few lines. If you insert data within the spreadsheet it will be
included with anything like sorting. However, data added to the end is not
always included. I've got round it by changing the print area (Click on
<Insert<Name<Define<Print_Area). I've not had this problem too many
time so I haven't been able to study it so I'm not sure what causes the
problem or why that should work and there may be a better way out of it.

Hope this helps.

Bill Ridgeway
Computer Solutions

"Richard" wrote in message
...
I have a 2075 row database that I autofilter by technical area
(i.e. Data/Filter/Autofilter on technical area column header).

The filter works fine, except no matter what technical area I select from
autofilter pulldown, the last row always displays.

I have double checked that there are no empty cells in the last row.
I have also verified that there are no empty cells in the last row by
writing a short macro that starts on column A of the last row, then
xltoRight
(i.e. Range("a2075", Range("a2075").End(xlToRight)).Select does indeed
select all the cells in the data set)

Any ideas why the last row doesn't my autofilter apply to the last row?
--
Richard