opening the sorting window with VBA

[jean]

Hi

I have a worksheet containing 30 columns and 1000 rows

I want to create a button that when user click on it, the range a9 to
ac1009 is selected and that the sorting command windows pop up. (same
as if you click DATA - SORT)

So the user click the button, the range is selected automatically and
the sorting window opens. After user make is own choice of sorting.

I know how to do the first part but I am not able to open the sorting
windows after the range is selected

Hope my question is clear

thanks

 

[Gord Dibben]

Have you tried the macro recorder?


Gord Dibben MS Excel MVP

 

[jean]

Have you tried the macro recorder?

Gord Dibben     MS Excel MVP











- Show quoted text -

Yes I have try using the macro recorder. But was not possible to stop
recording when the sorting window was open

 

[Dave Peterson]

Maybe you can use something like:

ActiveSheet.range("a9:ac1009").Select
Application.Dialogs(xlDialogSort).Show

 

[jean]

Maybe you can use something like:

     ActiveSheet.range("a9:ac1009").Select
     Application.Dialogs(xlDialogSort).Show

thanks
work perfectly