Forum Discussion
Solved
Hide/Unhide Rows in Excel in multiple sheets
I have a data in more than 40 sheets with same format. In "Column AX", I have total of all. Data format:- "top to bottom is date amd left to right is brands". In Column AX top to bottom is total of al...
- Thanks. I'll check & let you know whether it works for me or not.
Whether the following macro works or not depends on the layout of your worksheets...
Sub HideZeros()
Dim wsh As Worksheet
For Each wsh In Worksheets
Select Case wsh.Name
' List the exceptions here, if any
Case "Introduction", "Summary"
' Skip these sheets
Case Else
wsh.UsedRange.AutoFilter Field:=50, Criteria1:="<>0"
End Select
Next wsh
End Sub
Thanks. I'll check & let you know whether it works for me or not.
- Nott working for me