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

Bringing up sort command
 

How do you bring up the Sort userform

Hi.
Application.Dialogs(xlDialogSort).Show

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


"don" wrote in message
...
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