Halt auto functions

[Livin404]

Greetings yesterday "Joe4" from this website provided me the following VBA. It works great. The problem I have is it will continue to Delete Columns if I try to make any edits, such as delete a row. After the initial paste I don't need any further VBA action. Any advice would greatly be appreciated. Thank you,

Private Sub Worksheet_Change(ByVal Target As Range)
    Application.EnableEvents = False
    Call delCol
    Application.EnableEvents = True
    Columns.AutoFit
End Sub

 

[Joe4]

We need to define the conditions when we want it to run versus when we don't.
Usually, it is done by looking at update to a particular range of cells and/or specific values being entered.
If you can better define those conditions, we may be able to modify the code for your needs.
Note that I do not know of a good way to differentiate a "paste" versus manually entering something into a cell (both are considered cell edits), so I think we need something more to work off of.