I'm new to xl programming and need to know how to clear an advanced
filter programatically.


I'm applying a filter within the program to a named range, but I can't
clear the filter and redisplay all the data. If I use
activesheet.showalldata, it works if the range is filtered, but
generates an error if the range is already completely displayed.

Thanks