View Full Version : Hide Rows based several values
agnesz
10-01-2007, 08:30 AM
I need to hide a row if any of the rows 195 through 796 in column I contains any of the following words:
Mike
Sunny
Patti
Dennis, etc.
Please help!
Thank you,
az
Bob Phillips
10-01-2007, 08:44 AM
Sub ProcessData()
Dim i As Long
Dim ary
    
    Application.ScreenUpdating = False
    ary = Array("Mike", "Sunny", "Patti", "Dennis")
    For i = 796 To 195 Step -1
    
        If Not IsError(Application.Match(Cells(i, "I").Value, ary, 0)) Then
            Rows(i).Delete
        End If
    Next i
    
    Application.ScreenUpdating = True
End Sub
agnesz
10-01-2007, 10:08 AM
I just want to hide the row though, not delete it...
Can you adjust the code?
thanks so much!
Bob Phillips
10-01-2007, 10:14 AM
Rows(i).Hidden = True
Powered by vBulletin® Version 4.2.5 Copyright © 2025 vBulletin Solutions Inc. All rights reserved.