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

If ActiveSheet.FilterMode Then ActiveSheet.ShowAllData

--
Jim
<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
| 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
|

If activesheet.Filtermode then
activesheet.showalldata
End if

--
Regards,
Tom Ogilvy

"(E-Mail Removed)" wrote:

> 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
>
>