Thread: Hiding rows
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ordnance1[_2_] ordnance1[_2_] is offline
external usenet poster
 
Posts: 92
Default Hiding rows

I need to be able to hide/unhide rows base upon a value.

If cell P5 has a value of 1, then hide rows 6,7,8 and 9
If cell P5 has a value of 2, then hide rows 7,8 and 9
If cell P5 has a value of 3, then hide rows 8 and 9
If cell P5 has a value of 4, then rows 6, 7, 8 and 9 would be visible

Would like to do this as a WorksheetChange event.