Hi,

NOTE: Pls test it first and see if the result is what you want.
Then apply to your data sheets.

' =========================
Private Sub Worksheet_Change(ByVal Target As Range)
Dim row As Integer

row = Target.row
If Target.Column = 14 Then
Cells(row, 1).Clear
Cells(row, 15).Clear
Cells(row, 16).Clear
End If
End Sub
' =========================


"Esrei" wrote:

If I tipe a value (text) in N I want the values in the
same row in O P & A to be deleted. Please help