Wrap your code within the Enableevents eg
Private Sub Worksheet_Change(ByVal Target As Range)
Dim C As Long
C = Target.Column
application.enableevents=false
Select case
Case is =1
Call Macro1
Case is =2
Call Macro2
End Select
application.enableevents=true
End Sub
Bookmarks