Code below works, but how can it be modified to accomodate "X" in the following cells and row immediately below is unhidden: I15, I17, I20, J23, J25, J30 & J32?
Private Sub Worksheet_Change(ByVal Target As Range)
Dim rng As Range
Set rng = Me.Cells(13, "I")
If Not Intersect(rng, Target) Is Nothing Then
If UCase(Target.Value) = "X" Then
Rows("9:11").EntireRow.Hidden = False