VBA problem - subroutine not running

[apollo]

I'm having trouble running VBA code. BA is updating my Excel spreadsheet but the Worksheet_Change(ByVal Target As Range) function isn't being called. In order to investigate I've stripped the code down to the following - the worksheet it is attached to is called 'master'. It is the only instance of code attached to a worksheet and the only instance of code using a 'change' event. Other code is residing in modules as subroutines but isn't being called.


Private Sub Worksheet_Change(ByVal Target As Range)

MsgBox ("pre 16 count check")

If Target.Columns.Count = 16 Then

Application.EnableEvents = False

MsgBox ("after 16 count check")

Application.EnableEvents = True

End If

End Sub

-----------

I can see the data being updated on the sheet but no 'msgbox' messages appear. I'm baffled. Anyone?

[bolpx001]

I had a similar issue and discovered it was because the initial routine was interrupted and that had left Application.EnableEvents set to false I wrote another sub to set Application.EnableEvents = True and everything worked out fine - Paul

[apollo]

Thanks for the reply Paul - I haven't tested it yet but your answer sounds very convincing. As I'm building a spreadsheet and running it as I go it is sometimes left in an unresolved state as I debug an issue. I'm confident that you're right - thanks again - Dean