Hi,
I have found code that works that will delete certain cells if I change a key cell. e.g: If I change call B15 then cells C15: F15 get wiped - and the following works ok
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("B15)) Is Nothing Then
Range("C15:F15").ClearContents
End If
End Sub
So how can I amend the code so it works on each line from 16 to say 100 - where it'll on wipe the data on the corresponding line?
Thanks
I have found code that works that will delete certain cells if I change a key cell. e.g: If I change call B15 then cells C15: F15 get wiped - and the following works ok
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("B15)) Is Nothing Then
Range("C15:F15").ClearContents
End If
End Sub
So how can I amend the code so it works on each line from 16 to say 100 - where it'll on wipe the data on the corresponding line?
Thanks