Hi All.
I'm newer in VBA. I will appreciate for help creating vba procedure. I would like to hide/show range of cells by that condition:
    If Range("$M$2") = "Apr" Or "Jun" Or "Sep" Or "Nov" Then
           Range("$L$20:$L$27").EntireRow.Hidden = True
    ElseIf Range("$M$2") = "Feb" Then
           Range("$J$20:$L$27").EntireRow.Hidden = True
    Else
           Range("$J$20:$L$27").EntireRow.Hidden = False
    End If
What I mean. If value in cell M2 changed then according range will hide or show. If it posible how to do it?
Thanks.