Hi Guys,
I want to run a Macro if I change the value in "H3" (Which is working) but along with that, I want to activate the value in "H3" with "A2" if I change the value in "A2"
Could you correct it for me, please?
Thank you in Advance.
I want to run a Macro if I change the value in "H3" (Which is working) but along with that, I want to activate the value in "H3" with "A2" if I change the value in "A2"
Could you correct it for me, please?
Thank you in Advance.
VBA Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$H$3" Then
Call Hide_Unused_Rows
End If
If Target.Address = "$A$2" Then
Range("H3") = Range("A2").Value
End If
End Sub