Thread: group filtering
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ben McClave Ben McClave is offline
external usenet poster
 
Posts: 173
Default group filtering

Assuming you have data in columns A:J, this should work:

Sub FilterAll()
Dim WS As Worksheet
For Each WS In ThisWorkbook.Worksheets
WS.Cells.AutoFilter 11, "<"
Next
End Sub

-Ben