Thread: Bringing up sort command

How do you bring up the Sort userform as part of a subroutine.

I would like to have a macro highlight a certain area of a spreadsheet
and then bring up the Sort command for a manual sort.

Thanks in advance for any help.

Don

> How do you bring up the Sort userform

Hi.
Application.Dialogs(xlDialogSort).Show

--
HTH. :>)
Dana DeLouis
Windows XP, Office 2003


"don" <don8888@gmail.com> wrote in message
news:7blm82plb78f52s97ic6k6hhqoi06kq8o2@4ax.com...
> How do you bring up the Sort userform as part of a subroutine.
>
> I would like to have a macro highlight a certain area of a spreadsheet
> and then bring up the Sort command for a manual sort.
>
> Thanks in advance for any help.
>
> Don