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.

Don Guillett wrote:
try recording a macro while you are doing it.

Maybe you can use Bill Manville's post from a couple of years ago:
http://groups.google.com/groups?thre...0ADE%40iies.es

(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 wrote:

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.

Don Guillett wrote:
try recording a macro while you are doing it.


--

Dave Peterson

Thanks! This is just what i wanted!


Dave Peterson wrote:

Maybe you can use Bill Manville's post from a couple of years ago:
http://groups.google.com/groups?thre...0ADE%40iies.es

(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 wrote:

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.

Don Guillett wrote:

try recording a macro while you are doing it.

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

R Avery wrote:

Thanks! This is just what i wanted!

Dave Peterson wrote:

Maybe you can use Bill Manville's post from a couple of years ago:
http://groups.google.com/groups?thre...0ADE%40iies.es

(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 wrote:

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.

Don Guillett wrote:

try recording a macro while you are doing it.




--

Dave Peterson