I do not want to sort a range by VBA because the sort window is more general and give more selection. The sort window in excel can appear by the shortcut: "Alt + H + S + U". But can we write a macro that (select a special range of a sheet and) show this window?

>Solution :

If the activecell is filterable then use:

Application.Dialogs(xlDialogSort).Show