Tom Ogilvy posted some code for this in the following thread:
http://groups.google.com/groups?&thr...upernews.co m
Talon wrote:
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
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html