HI
I want to clear the contents of certain cells in Sheet2 (B1:B6,C1:C6) when the content of the cell Sheet2 (A1) is changing. i have done using the below code but the difficult part is
Sheet2 (A1) is fetching date value from Sheet1 using a formula (=IF(CarOwners!$I$4>=TODAY(),CarOwners!K4,"YES")). So the formula remains the same but only the value in A1 changes when its corresponding cell K4 in Sheet1 changes.
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("A1")) Is Nothing Then
Range("B1:B6,C1:C6").ClearContents
End If
End Sub
This code works when the formula itself changes but does not work when the value fetched by the formaula changes.