Hi,
I have below code to hide the Rows 25 to 28 based on the selection in the Cell E24(Like If ,
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("E24")) Is Nothing Then Exit Sub
Select Case Target.Value
Case "No"
Rows("25:28").EntireRow.Hidden = True
Case "Yes"
Rows("25:28").EntireRow.Hidden = False
End Select
End Sub
However my requirement is to apply this same logic in many rows in the same excel sheet.Eg. In place of E30 is "Yes" then Rows from 31 to 38 to be hide,E49 is "Yes", then Rows 50 to 60 to be hide and so on at many Rows inn same excel.
Can anyone help on this at the earliest.
Bookmarks