opening the sorting window with VBA

  • Thread starter Thread starter jean
  • Start date Start date
J

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
 
Have you tried the macro recorder?

Gord Dibben     MS Excel MVP











- Show quoted text -
Click to expand...

Yes I have try using the macro recorder. But was not possible to stop
recording when the sorting window was open
 
Maybe you can use something like:

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