My worksheet change event macro is like this:

Private Sub Worksheet_Change(ByVal Target As Range)
Dim n As Integer
Application.ScreenUpdating = False
Application.EnableEvents = False 'prevents change event indefinite loop

<Loop macro resets formulas in 20 rows in one column using counter n

Application.EnableEvents = True
Application.ScreenUpdating = True
End Sub

The macro works sometimes but fails intermittently. This happens even if I
comment out the EnableEvents = False/True code.
Any ideas on why it could be failing and/or how I could investigate would be
appreciated, thanks.
--
Partho