Hi,
I am trying to convince the following code work for me:
...but it doesn't. I have saved the file as .xlsm, added the above piece as a "module" (General/Worksheet_Change) but whenever I update values in cells A5:A8, entry in cell A2 is not automatically erased as expected. Please help?
I am trying to convince the following code work for me:
VBA Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("A5:A8")) Is Nothing Then
Range("A2").ClearContents
End If
End Sub