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.


---
Message posted from http://www.ExcelForum.com/