group filtering

  • Thread starter Thread starter kijijijt
  • Start date Start date
K

kijijijt

I would like to filter out blanks in column K in all sheets within a workbook. For some reason when the sheets are grouped the filter option is not available. I appreciate any help. thanks.
 
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
 
I would like to filter out blanks in column K in all sheets within a workbook. For some reason when the sheets are grouped the filter option is not available. I appreciate any help. thanks.
Click to expand...

works, thanks.
 
Back
Top