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.