Re: $$Excel-Macros$$ sort on 3 columns

2016-01-26 Thread Paul Schreiner
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

$$Excel-Macros$$ sort on 3 columns

2016-01-26 Thread Frank V
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