Looking for blanks or zero or strings cells in a range

[Mauricio Samy Silva]

Hello,
The above command line looks for blanks cells in range G2:G157 and hidde the row.
I need look for cells whith names (strings)in it and others whith 0 (zero) in it.
Help me whith the code!!!!
Many thanks

ActiveSheet.[G42:G157].SpecialCells(xlCellTypeBlanks).EntireRow.Hidden = True

Mauricio

 

[white6174]

hope this helps
steve w


For Each Cell In Range("G42:G157")
Cell.Select
If Cell.Value = "" Or Cell.Value = 0 Then
Selection.EntireRow.Hidden = True
End If
Next