Macro to filter from Sheet6 Onwards Column B

[howard]

I would like to filter Col B on all sheets from sheet 6 onwards and to exclude zeroes in the filter


It would be appreciated if someone could kindly amend my code below

 Sub auto_filter_all_sheets() 
Dim ws As Worksheet 
Application.ScreenUpdating = False 

if selection.Rows.count < 3 then exit sub 
sAddress = Selection.Address 
For Each ws In ActiveWindow.SelectedSheets 
    ws.Range(sAddress).AutoFilter 
Next ws 
Application.ScreenUpdating = True 
End Sub

 

[footoo]

https://www.mrexcel.com/forum/excel...autofilter-everything-but-certain-values.html

 

[howard]

Thanks for the reply


Kindly amend the code below so that I can filter the zeroes on all sheets from sheet6 onwards

 Sub filter_Zeroes

Dim c As Range, rng
 Set rng = Range("B1:B2000")
 For Each c In rng
 If c.Value = "0" Then
 c.EntireRow.Hidden = True
 End If
 Next c 
End Sub