If I enter 35 data validation isn't triggered and the VBA "logic" doesn't loop (at any time)
If I enter 950 data validation (in Excel not VBA) is triggered and retry is selected - enter 35 and the VBA "logic" loops twice
I'm using Worksheet_Change(ByVal Target As Range)
I'm using Application.EnableEvents = False
with calling of several sub-routines.
I reset the Application.EnableEvents to True only once at the end of the Worksheet_Change sub()
Is there another "setting" that needs to be controlled - in addition to EnableEvent?
PS - I'm also controlling ScreenUpdating.