In cell "S1" I have the formula that brings today.
I need that when this formula is updated, the value of cell "T3" automatically returns to 0.
In the codes I tested, it works only if I change the value manually, but I need it to happen automatically.
Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Me.Range("S1")) Is Nothing Then Range("T3").Value = 0 End If End Sub
The code above occurs when I change the date of cell S1 manually, but that’s not what I’m looking for, so I know I need to do this in the Worksheet Calculate event, but I don’t know the code.