Does excel trigger an event when you sort a list? If so how can I catch it?
Does excel trigger an event when you sort a list? If so how can I catch it?
Sorting doesn't trigger an event.
However if you have a formula like =COUNTA(A:A) in an inconspicuous cell, it will re-calculate whenever column A is sorted (even when A is not the key column). That will trigger a calculate event.
I see. I think that may help. Thanks.