If ActiveSheet.FilterMode Then ActiveSheet.ShowAllData

--
Jim
wrote in message
ps.com...
| 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
|