View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JEFF JEFF is offline
external usenet poster
 
Posts: 5
Default Testing the results of a formula for zero

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