hide rows based on criteria

[kingcashandcarry]

Hello
this code hides rows that in c column the value is 0
i want the c.value to be between -1 and +1
i tried some things but fails any help?

Sub HideRowelypol()
Application.ScreenUpdating = False
Application.Calculation = xlManual
For Each c In Range("c2:c1199")
  If c.Value = 0 Then Rows(c.Row).Hidden = True
Next
Application.Calculation = xlAutomatic
Application.ScreenUpdating = True
End Sub

 

[Hui]

Sub HideRowelypol()
Application.ScreenUpdating = False
Application.Calculation = xlManual
For Each c In Range("c2:c1199")
  If c.Value > -1 and  c.Value < 1 Then Rows(c.Row).Hidden = True
Next
Application.Calculation = xlAutomatic
Application.ScreenUpdating = True
End Sub

 

[Hareesh_KLD]

Hi,

You can not hide single cell ...you need to hide the entire row belonging to that cell.

Sub HideRowelypol()
Application.ScreenUpdating = False
Application.Calculation = xlManual
For Each c In Range("c2:c1199")
  If c.Value = 0 Then c.EntireRow.Hidden = True
Next
Application.Calculation = xlAutomatic
Application.ScreenUpdating = True
End Sub

 

[kingcashandcarry]

thanks Hui Just perfect and fast answer for one more time chandoo save my day

 

[Hareesh_KLD]

Hello
this code hides rows that in c column the value is 0
i want the c.value to be between -1 and +1
i tried some things but fails any help?

Sub HideRowelypol()
Application.ScreenUpdating = False
Application.Calculation = xlManual
For Each c In Range("c2:c1199")
  If c.Value = 0 Then Rows(c.Row).Hidden = True
Next
Application.Calculation = xlAutomatic
Application.ScreenUpdating = True
End Sub

your code also running fine for me