hi
is there any help to make the code delete range from A: L instead of entire row when change value in column A ?
this is the code
is there any help to make the code delete range from A: L instead of entire row when change value in column A ?
this is the code
VBA Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Columns(1)) Is Nothing Then
Application.EnableEvents = False
Target.EntireRow.Delete
End If
Application.EnableEvents = True
End Sub