1

Topic: Excel VBA: whether probably to trace sorting event?

Hello.
There is a book with a heap of tables where from time to time do sortings according to different criteria.
Problem in that I should trace such events of sorting.
Tried to use event Worksheet_Change, but it does not work at sorting.
The people, prompt, whether there is a possibility to intercept sorting event?

2

Re: Excel VBA: whether probably to trace sorting event?

MAULER;
Place on sheet "volatile" function e.g. = () and use Worksheet_Calculate.

3

Re: Excel VBA: whether probably to trace sorting event?

The Kazan;
Explain please, what "volatile function" means?

4

Re: Excel VBA: whether probably to trace sorting event?

MAULER;
[quote =] Volatile (changed, changeable, ) - what are enumerated at any changes on sheet irrespective of, whether the initial data of these functions exchanged.