Thread: VBA and "If"?!
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jo[_2_] Jo[_2_] is offline
external usenet poster
 
Posts: 69
Default VBA and "If"?!

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

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

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