autofilter

[Guest]

hello and good new year

i'm on w2k and office 2003

on excel when i do two cols
A B
1 =a+1
2 =a+1
etc.....
i go to for example 500
and after i make auto filter on A and B if i use autofilter i see Filter mode
but if after i do only 10 line and not 500 i have 1 of 500 records found and
not 1 of 10.
i have two problem : with 500 line i have not the count of record found and
if i delete some line i must desable autofilter for have the good count of
line


thanks for your help

 

[Dave Peterson]

Debra Dalgleish as some work arounds at:
http://www.contextures.com/xlautofilter02.html#Count

I didn't have to disable the filter, but I did have to do a ShowAll, then
reapply that filter criteria to get the row count back (after deleting rows).