Hiding groups of Rows in multiple Worksheets in Excel

Also if you want to add a filter lets say you don't want to apply this in sheet1 and sheet2 then you have to use something like this..

Sub HideRows()
    Dim ws As Worksheet
    Dim cell As Range
    For Each ws In ActiveWorkbook.Worksheets
        If UCase(ws.Name) <> "SHEET1" And UCase(ws.Name) <> "SHEET2" Then
            For Each cell In ws.Range("J7:J1452")
                If Not IsEmpty(cell) Then
                    If cell.Value = 0 Then
                        cell.EntireRow.Hidden = True
                    End If
                End If
            Next cell
        End If

    Next ws
End Sub

Select allOpen in new window

Please note if statement in VB is case sensitive that's why i have converted your ws.name in upper case in VB...

Saurabh...

In my answer above the

Next
End Sub

should also be in the code.

Is there a way to specify exactly which worksheets as opposed to all of them?

Sure. See post ID 40749615.

To specify worksheets..Change this line..

If UCase(ws.Name) <> "SHEET1" And UCase(ws.Name) <> "SHEET2" Then

Select allOpen in new window

to this..Assuming you want to run for sheet1 and sheet2 only..

If UCase(ws.Name) = "SHEET1" Or UCase(ws.Name) = "SHEET2" Then

Select allOpen in new window

Saurabh...

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.