How to hide a row Conditionally ?

[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

[Ivan F Moala]

On 2002-05-03 11:11, 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

You would have to use Event code to do this.
2 questions;
1) How is b5 being changed ? via formula or
user input ?
2) What do you want to happen if b5 does not = 5

[pra]

user inputs this data. I am looking for something like this
if b5:b10="Jack" or "Molly" then hide that particular row(s)

[Tom Schreiner]

Private Sub Worksheet_Change(ByVal Target As Range)

Dim c

For Each c In Range("B5:B10")

    If c = "Jack" Or c = "Molly" Then _

       Rows(c.Row).EntireRow.Hidden = True

Next

End Sub

Right-click on your sheet tab, choose view code, paste this in there...

Tom

[Jack in the UK]

Sub Hide_Rows()

On Error GoTo Z
Sheets("B W").Select
Range("A1:R500").Select
Selection.Interior.ColorIndex = xlNone
Range("A1").Select
Application.ScreenUpdating = False
Rw = 1
'>>>>>>>>>>>>>>>>>>>>
With Sheets("B W") For Hide1 = 1 To WorksheetFunction.CountIf(.Columns("M:M"), "PAID")
Set RHIDEFoundCell = .Columns("M:M").Find(What:="PAID", _
After:=.Cells(Rw, 13))
RHIDEFoundCell.EntireRow.Hidden = True
Rw = RHIDEFoundCell.Row
Next Hide1
End With
'>>>>>>>>>>>>>>>>>>>>>

Range("A1").Select
Application.ScreenUpdating = True

Z:
End Sub

edit as needs be (rare i post VBA thisis one i use ever day, just add as many as you need and link to command button, targets sloe systems, so i choose command)




*MARKER HIDE ROWS*

[mapakunk]

Is there a reason why you are not using an autofilter? Wouldn't it be simpler?

[Jack in the UK]

my code knows no limits just add add add.. and trigger on command