HI,
I'm trying to clear content of F9 and F10 cell if D9 has value1205.
I used the macro below however, it didn't work
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$D$9" Then
If Target.Value = UCase("1205") Then Sheets("Sheet2").Range("f9:F10 ").ClearContents ""
End If
End Sub
I have Microsoft 365
Thank you for your time
I'm trying to clear content of F9 and F10 cell if D9 has value1205.
I used the macro below however, it didn't work
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$D$9" Then
If Target.Value = UCase("1205") Then Sheets("Sheet2").Range("f9:F10 ").ClearContents ""
End If
End Sub
I have Microsoft 365
Thank you for your time