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!

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
Thank you in advance!