Hi Sarah
Rather than Autofilter, I would try Insert tabTablemy table has headers.
This will insert the filter arrows in the header row by default, then use
them to filter your data.
I have never known the Table object to get it wrong.
--
Regards
Roger Govier
"Sarah H." wrote in message
...
Thanks for the further elucidation. As a matter of fact, I also am
creating this sheet automatically from a macro that merges other sheets
together. I'm using a macro that started out from one of Ron de Bruin's
merge VBA examples - http://www.rondebruin.nl/tips.htm . But I edited it
extensively and have been using it for a couple of years in its present
form under Excel 2002. Just now I'm trying to remake the entire thing for
Excel 2007 because of various annoyances and incompatibilities with my
2002 macros and ranges. The merge macro works fine as it was, but this
problem now arises with autofilter.
I appreciate your workaround idea (and might have to do as you suggest in
the short run), but in all honesty I am too fastidious to be satisfied
with a kludge of that degree after having decided to dive in and fully
convert my sheets to optimize in native Excel 2007 form. I am still in
jaw-drop mode that such a problem can be happening. It's not as if Excel
2007 just came out last week! Do you or does anyone have a suggestion for
how I can get Microsoft support in on this?
(Gee, maybe I should have spent my effort re-coding for Open Office
instead. Then at least I could also run under Linux.) :-)
--
Sarah
"Dave Peterson" wrote in message
...
I was going to include this in my first response, but I didn't want to
add
clutter if it wasn't necessary.
I had an xl2k workbook that I created from scratch each morning from data
from
various sources (it was a mechanized routine).
I had that same exasperating problem. The last row of the data just
wouldn't be
included--even if I did it manually.
This was the only time (over and over and over) I've seen this problem.
My workaround (not quite a solution) was to add something to column A of
the row
under the last row. Then filter the range through this lastrow+1. After
I
applied the filter, I'd clear the cell (just clearcontents).
The only problem that the stupid filter included this lastrow+1 in its
range!
So I'd see "blanks" as one of the options for the filtering dropdowns.
But I decided that I could live with that irritation to get the real last
row
included.
Maybe it'll work for you and you'll lower your standards to allow this
other
irritation.
"Sarah H." wrote:
Dave,
Yes, the last row is not included in the filter range. But nothing I
can do
will get it to be included! That is the problem. If I turn off
autofiltering and turn it back on with the entire range selected
manually,
Excel still leaves the last row unfiltered and creates a new
sheetname!_FilterDatabase range leaving out the last row.
Even if I manually select the blank row following the last row and turn
on
autofilter with that selection active, the problem still occurs.
This is the silliest thing! I mean, millions of people are using Excel
2007
and autofilters. How can such a basic problem be biting me like this?
I
don't get it. Nor am I a newbie. Oh, well, what other ideas do you
have?
Much obliged.
S
"Dave Peterson" wrote in message
...
Next time you do this, look at that last row that should not be
visible.
Notice the color of the row number for that row compared to the row
numbers of the visible rows in the filtered range.
I bet it's not the same.
That means that this row wasn't included in the range to be
filtered.
I'd remove the filter, and then select the range to filter. (I
never let excel guess!)
Then test again.
Did it work?
"Sarah H." wrote:
Hi, all,
I recently started using Excel 2007 after having used older
versions for many years.
I am having a baffling issue with AutoFilters. I turn on filters,
select a criterion, and find that the lowest row in my data table
shows up regardless, even though it should have been filtered out.
I also note that the automatically created _FilterDatabase range
on my sheet ends one row too soon. But if I edit or delete that
named range, the problem does not resolve. Nothing different
happens at all.
Help?
--
Dave Peterson
--
Dave Peterson
__________ Information from ESET Smart Security, version of virus
signature database 4540 (20091025) __________
The message was checked by ESET Smart Security.
http://www.eset.com
__________ Information from ESET Smart Security, version of virus signature database 4540 (20091025) __________
The message was checked by ESET Smart Security.
http://www.eset.com