tricky one eh??

[pra]

how do I conditionally hide a row? for example if b5="Jack" then the entire row should be hidden. Pls help.. Thanks in advance

[Jay Petrulis]

On 2002-05-03 11:04, pra wrote:
how do I conditionally hide a row? for example if b5="Jack" then the entire row should be hidden. Pls help.. Thanks in advance

In a sheet module, use wither a worksheet_change or a worksheet_selectionchange event

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
If Range("B5") = "Jack" Then
Rows(5).Hidden = True
Else
Rows(5).Hidden = False
End If
End Sub

EDIT:

Please don't start a new thread with the same question.

Also, please allow some time before you post and then repost. 7 whole minutes elapsed before your first request until the second one. Be reasonable. Not everybody can be your personal Excel consultant. A little patience for you!

[ This Message was edited by: Jay Petrulis on 2002-05-03 11:43 ]

[Ivan F Moala]

Jay is right....please don't restart
another thread...otherwise people will
waste there time.....I just queried another
one of your Q above and now find that Jay
has answered you. :-0