What do you mean by does not work.

Selection.AutoFilter

will toggle the autofilter on and off

if you mean showall, it should work as well if the datafilter is actually
on.

Show the code that isn't working. You experience is atypical.

--
Regards,
Tom Ogilvy

"R Avery" wrote in message
...
I have an Autofilter. I want to be able to toggle the current filter on
and
off. I already have a mechanism in place that does this. however, it
does
not work when one of the columns is filtered for "Blanks" or "nonblanks".
A
workaround is to explicitly custom filter for equal "" or not equal ""...
but it seems a little roundabout. I have not found any help in the object
browser or the Help files.

Any help would be appreciated. Thanks!