# How to Hide Row According to "Zero"

[krunal123]

Pleased make this VBA script ......

Find to Zero value on row & hide this row

 

[ER_Neha]

Hello, try this..

Sub Hide_Columns_Containing_Zero()
  Dim c As Range
  For Each c In Range("e2:e13").Cells
    If c.Value = "0" Then
        Range(c.Address).EntireRow.Hidden = False
    Else
        Range(c.Address).EntireRow.Hidden = False
    End If

    Next c
        
    
End Sub

 

[krunal123]

Hello, try this..

Sub Hide_Columns_Containing_Zero()
  Dim c As Range
  For Each c In Range("e2:e13").Cells
    If c.Value = "0" Then
        Range(c.Address).EntireRow.Hidden = False
    Else
        Range(c.Address).EntireRow.Hidden = False
    End If

    Next c
        
    
End Sub




I put on this script on vba not showing result plz help step by step.......