Refreshing Autofilter

[R Avery]

In XL 2002, how do you refresh an autofilter? For example, if i have a
range that has been autofiltered manually with 6 conditions, and then I
run a macro that changes some of the underlying data, how do i refresh
the autofilter such that it reflects the new data?

 

[Don Guillett]

try recording a macro while you are doing it.

 

[R Avery]

This does not help. Once you have taken off an autofilter, the
worksheet does not retain the state that the autofilter had before it
disappeared. Therefore, i cannot return to the previous state without
using Undo, which is unacceptable.

I do not need to know how to create filters programmatically, I need to
know how to restore whatever Autofilters were just on before i clicked
teh "Show all data" method, and the filters that are on can be any
random filters the user wishes.

 

[Dave Peterson]

Maybe you can use Bill Manville's post from a couple of years ago:
http://groups.google.com/[email protected]

(I used to worry about this, too. But I've stopped. With my own data, I find
that I do data|filter|showall so ofter, that it's not too bad to reapply (and
possibly change) my filter criteria.)

 

[R Avery]

Thanks! This is just what i wanted!

Maybe you can use Bill Manville's post from a couple of years ago:
http://groups.google.com/[email protected]

(I used to worry about this, too. But I've stopped. With my own data, I find
that I do data|filter|showall so ofter, that it's not too bad to reapply (and
possibly change) my filter criteria.)

 

[Dave Peterson]

The code from Bill or my note saying it's ok to stop worrying about it <vbg>.