Hello I have need of VBA knowledge of which I know enough of to know that I know nothing.
Currently I have found this VBA Macro to clear the contents of E2, if the content of E1 changes
Private Sub Worksheet_Change(ByVal Target As Range)
'When E1 changes, E2 clears, and c20, d20 .... j20 all clear.
If Target.Address(0, 0) = "E1" Then Range("E2").ClearContents
End Sub
I need to be able to do the same function on multiple other cells each with their own reference.
ie: G1 to clear G2, I1 for I2 and so on,
with various non-incremental addresses (if that matters)
As always, any help would be greatly appreciated.
Bookmarks