Hello,
Thank you to all who help out on the forum... You make me much smarter than i am.
I am working on a sheet and am stuck with some VBA coding.
As the title says i am looking to hide and unhide rows based on cell values. I am currently using a "extractwordinstring" formula to provide a true false statement. In my case the true / false shows in L23 : L33. I am looking for a formula that if L23 is true unhides row 34:35, if L24 unhide row 36:37, ect...
I have been able to get as far as the first set of rows hiding and unhiding using:
Private Sub worksheet_Change(ByVal Target As Range)
If Range("l24").Value = False Then
Rows("34:35").EntireRow.Hidden = True
ElseIf Range("L24").Value = True Then
Rows("34:35").EntireRow.Hidden = False
End If
End Sub
How can i expand upon this?
Thanks again,
Rob
Thank you to all who help out on the forum... You make me much smarter than i am.

I am working on a sheet and am stuck with some VBA coding.
As the title says i am looking to hide and unhide rows based on cell values. I am currently using a "extractwordinstring" formula to provide a true false statement. In my case the true / false shows in L23 : L33. I am looking for a formula that if L23 is true unhides row 34:35, if L24 unhide row 36:37, ect...
I have been able to get as far as the first set of rows hiding and unhiding using:
Private Sub worksheet_Change(ByVal Target As Range)
If Range("l24").Value = False Then
Rows("34:35").EntireRow.Hidden = True
ElseIf Range("L24").Value = True Then
Rows("34:35").EntireRow.Hidden = False
End If
End Sub
How can i expand upon this?
Thanks again,
Rob