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:
What I mean. If value in cell M2 changed then according range will hide or show. If it posible how to do it?![]()
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
Thanks.
Bookmarks