Sort / subsort a range of cells based on the cell selected ??

Crossposted to

https://www.mrexcel.com/forum/excel-...-selected.html

Hi I'd like to automate excels inbuilt sort / subsort for a non static range of cells ...

The range is based on

5 columns including and adjacent to the selected cell and say 66 rows down ...

Ie . EV4:EZ70
The initial range being sorted alphabetically by cells EY4:EY70

Then a subsort numerically EW4:EW70

Only to sort cells in the range that have values in EV4:EV70...

I'd also like to add a floating button or custom button to the quick access toolbar ??

When I record a macro I get this ??

Please Login or Register  to view this content.

Any help is appreciated ! Thanks