Vba Help :)

[mak]

Os
Just sort it out

You were right about my macros that were crashing

If someone interest your solution is the following

Dim lastrace As String
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Columns.count = 16 Then
Application.EnableEvents = False

If lastrace <> ThisWorkbook.Sheets(Target.Worksheet.Name).Range("A1").value Then
lastrace = ThisWorkbook.Sheets(Target.Worksheet.Name).Range("A1").value
'macros to run when event changes
MyMacro1
MyMacro2
End If
Application.EnableEvents = True
End If
End Sub


Thanks !