Prev: Making my App only work so many times
Next: What is the bar and function name for refresh all?
From: ordnance1 on 20 Mar 2010 00:18
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.
From: Rick Rothstein on 20 Mar 2010 01:22
Give this Change event code a try...

Private Sub Worksheet_Change(ByVal Target As Range)
Dim N As Long
If Target.Address = "$P$5" Then
N = Target.Value
If N > 0 And N < 5 Then
Rows("6:9").Hidden = False
If N < 4 Then Rows((5 + N) & ":9").Hidden = True
End If
End If
End Sub

Rick (MVP - Excel)


"ordnance1" <ordnance1(a)comcast.net> wrote in message
news:uOf#YR#xKHA.2436(a)TK2MSFTNGP04.phx.gbl...
> 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.

 | 
Pages: 1
Prev: Making my App only work so many times
Next: What is the bar and function name for refresh all?