How do I hide a ROW if cell value is zero in Excel
D David Billigmeier Dec 16, 2005 #2 Select the range of cells, then execute this macro: Sub HideRows() Dim rn As Range Dim rng As Range Set rng = Selection For Each rn In rng.Cells If (rn.Value = 0 And rn.Value <> "") Then Rows(rn.Row).Hidden = True End If Next End Sub
Select the range of cells, then execute this macro: Sub HideRows() Dim rn As Range Dim rng As Range Set rng = Selection For Each rn In rng.Cells If (rn.Value = 0 And rn.Value <> "") Then Rows(rn.Row).Hidden = True End If Next End Sub
