View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Dana DeLouis Dana DeLouis is offline
external usenet poster
 
Posts: 947
Default Recognizing cell change in a Sub Worksheet_Change procedure

.Rows("1:35").EntireRow.Hidden = False
.Rows("10:10").EntireRow.Hidden = True
.Rows("20:20").EntireRow.Hidden = True


Just an alternative:

.Rows("1:35").Hidden = False
.Rows(10).Hidden = True
.Rows(20).Hidden = True

--
Dana DeLouis
Windows XP & Office 2003


"AMY Z." wrote in message
...
Thanks Dave for taking time to rewrite my code, It Works!
Thank you also JNW and Gary for the tips.
Amy

<snip