hi
I have this code if change the value in column A should delete entire row , but it gives error and crash the code
I have this code if change the value in column A should delete entire row , but it gives error and crash the code
VBA Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Columns(1)) Is Nothing Then
Target.EntireRow.Delete
End If
End Sub