Strange "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 Thanks, Jo |
Strange "IF"?
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 |
All times are GMT +1. The time now is 08:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com