How do I hide a ROW if cell value is zero in Excel
 

How do I hide a ROW if cell value is zero in Excel

How do I hide a ROW if cell value is zero in Excel
 

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

--
Regards,
Dave


"wil4d" wrote:

How do I hide a ROW if cell value is zero in Excel