I have this code runs fine but, for Zone4=7, its row gets hidden
although it shouldn't according to the code below. What could I be
missing?

If Zone5 = 0 Then
Range("Zone5").Select
Selection.EntireRow.Hidden = True
End If


If Zone4 = 0 Then
Range("Zone4").Select
Selection.EntireRow.Hidden = True
End If


Thanks,
Jo

You have 2 responses in Excel programming. Please don't cross post... Check
out this link...

http://www.cpearson.com/excel/newposte.htm
--
HTH...

Jim Thomlinson


"Jo" wrote:

I have this code runs fine but, for Zone4=7, its row gets hidden
although it shouldn't according to the code below. What could I be
missing?

If Zone5 = 0 Then
Range("Zone5").Select
Selection.EntireRow.Hidden = True
End If


If Zone4 = 0 Then
Range("Zone4").Select
Selection.EntireRow.Hidden = True
End If


Thanks,
Jo