Private Sub Worksheet_Change(ByVal Target As Range) If (Target.Range="$C$3") And (Target.Range=$C$3) Then Call Macro1(Target.Address(False, False), Target.Value) End If End Sub
However And is not working. If (Target.Range=$C$3) And (Target.Range=$D$3) doesnt work. I know it works with OR.
What to do?