Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter across Worksheets
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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter across Worksheets
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2007 autofilter change to 2003 autofilter functionality? | Excel Discussion (Misc queries) | |||
2007 excel autofilter change back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
autofilter linked in different worksheets | Excel Discussion (Misc queries) | |||
Autofilter in protected worksheets | Excel Worksheet Functions | |||
Linking Worksheets and Autofilter | Excel Discussion (Misc queries) |