Can a window of excel (for example "custom sort" window) appear by macro?

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:


Leave a Reply