VBA code Deactivate events clear cell value

[vince]

Hi


I am new to VBA, is there a code I could use to clear out a value="Skipped" in range AJ:AJ ?


The problem is I have a change event running on the sheet so if I run a loop the message box keeps popping up that IT detects a change(I have created).


But I did include Application.EnableEvents = False before the start of the loop as an example but it still runs each time the loop executes.


How can I disengage the event while the loop runs from a general procedure.

 

[Colin Legg]

Setting

Application.EnableEvents = False should prevent the Worksheet_Change()

event handler from being called. Please post the relevant code (including the worksheet event handlers) so we can investigate it further?