Autofilter across Worksheets

[Talon]

I would like to be to able apply an autofilter across multiple
worksheets. My file contains about 20 worksheets that all require the
same autofilter. I tried recording a macro but it will only work for
the active sheet:

Sub Autofilter_no_zeros()
Selection.AutoFilter
ActiveWindow.LargeScroll ToRight:=1
Selection.AutoFilter Field:=14, Criteria1:="<>0", Operator:=xlAnd
End Sub

Thanks in advance for any help.

 

[Debra Dalgleish]

Tom Ogilvy posted some code for this in the following thread:


http://groups.google.com/groups?&[email protected]