Hi guys,
I have two separate macros that I want to run automatically. I have entered the script below (the first one is triggered by a change in B8 and the second one by a change in B21), however, it works for the first one only - the second one has to be run manually. Please help!
Thank you in advance!![]()
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$B$8" Then Call HideRows End If If Target.Address = "$B$21" Then Call HideRows2 End If End Sub
Bookmarks