PDA

View Full Version : Question about Sort Events



nameuser321
03-30-2012, 03:21 PM
Does excel trigger an event when you sort a list? If so how can I catch it?

mikerickson
03-30-2012, 04:38 PM
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.

nameuser321
04-02-2012, 06:13 AM
I see. I think that may help. Thanks.