Hello Forum,
I am trying to conditionally clear the content of cells, based on the content of an adjacent cell. I attached the spreadsheet with the code I have so far. Here is the VBA code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$E$7" Then
Range("F7").ClearContents
End If
End Sub
In the attached file, I have managed to clear the contents of cell F7 if the content of E7 is "Major". I would like to continue that for all cells below row 7 in those columns. However, as someone who does not know what they are doing, I am stuck. Can anyone help?
Thanks!
Bookmarks