by Betscrew » Sat Oct 11, 2014 9:11 am
Hi.
I have an Excel formula using Back and Update triggers:
IF(T5="","BACK","UPDATE")
I am often getting SelectionNotActive in the Betref cell. Sometime this means the original Back trigger fails and sometimes the Back trigger is activated but doesn't Update.
I think the problem might be that the Update trigger tries to fire before the Back trigger is complete. Is there a way to delay the Update trigger or maybe another fix for this problem?
Cheers,
Betscrew