Hi, I work on some projects and I maintain status of those in an excel file in column L. The status of the projects varies as I wrok (Stages). The final status of the project is named as "Completed". Now I want the whole row to get hide when I select the status "Completed" from the list. Eg. If I select L2 value be completed. Complete Row (ie., 2) shud get hidden. I have a macro which I find on the internet & I amended it a little bit for my needs with my very little VBA knowledge. But this is working only for 1st row. Below is what I have.
Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Range("L1").Value = "Completed" Then Rows("1").EntireRow.Hidden = True Else Rows("1").EntireRow.Hidden = False End If End Sub