Testing the results of a formula for zero

J

JEFF

I want to test the results of a formula to see if it is zero (or null) and
then hide the row if it is. Can someone show me the best way to do that?
Below is what I am trying...

If ActiveCell.Value <= 0 Then
Selection.EntireRow.Hidden = True
End If

Thanks and best regards,
Jeff
 
G

Gord Dibben

Sub test()
If ActiveCell.Value <= 0 Or ActiveCell.Value = "" Then
Selection.EntireRow.Hidden = True
End If
End Sub


Gord Dibben MS Excel MVP
 
Top