Hello
My question:
How can I make this macro run on all worksheets excluding only 2 worksheets in my workbook ?
Could someone please help me to solve this ?Sub Hide_Colors_Zeros() Dim Rng As Range Dim MyCell As Range Dim c As Range Set Rng = Range("B2:B1000") For Each MyCell In Rng If MyCell.Font.ColorIndex = 3 Then MyCell.EntireRow.Hidden = True End If Next MyCell For Each c In Range("S2:S1000") If c.Value = "Hide" Then c.EntireRow.Hidden = True End If Next End Sub