Hi. I was hoping for a little help coding this.

I'm using this to hide and show ranges on my sheet1

If Range("Blood").EntireRow.Hidden = True Then
        Range("Blood").EntireRow.Hidden = False
    Else
        Range("Blood").EntireRow.Hidden = True
    End If
I want an onchange even i think its called.

That as soon as "Blood" range which is on sheet 1 is hidden=false (visible) THEN

a range on sheet2 i have designated Blood_Show will automatically become unhidden

as soon as that range blood is hidden again then Blood_Show would again dissapear/behidden on sheet 2


Any help with this would be really appreciated! Thanks so much!