I'm having trouble understanding what you are trying to do.The terms don't
quite make sense.Automatic sort? What is that?if you record a macro and define
your sort, the issue is that the selected range becomes "hard-coded" into the
macro.SortFields.Add Key:=Range("I2:I766")
means that if you add
Hi,
automatic Sort with the macro recorder or normal sort with three levels do
not give me the expected results.
Sorting descending, between the same values in one column the other column
is not sorting any more, until the value changed again.
is there a routine already in VBA ?
PS there is no