How do I open the Sort dialog box using VBA?
Excel 2000.

Thanks
Pete

Hi,

You can sort from Vb without using the dialog box, perhaps it would be best
if you explained what you are trying to sort.

Mike

"PM" wrote:

How do I open the Sort dialog box using VBA?
Excel 2000.

Thanks
Pete

Sub aSortedAffair()
SendKeys "%d"
SendKeys "~"
DoEvents
End Sub


May not work for 2007
--
Gary''s Student - gsnu200777


"PM" wrote:

How do I open the Sort dialog box using VBA?
Excel 2000.

Thanks
Pete

Hi,

If you really must display the dialog then

application.Dialogs(xlDialogSort).Show

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"PM" wrote in message
...
How do I open the Sort dialog box using VBA?
Excel 2000.

Thanks
Pete

"PM" wrote in message
...
How do I open the Sort dialog box using VBA?
Excel 2000.

Thanks for all the replies.

I want the user to be able to sort a large named area where many cells are
blank. Simply opening the Sort dialog box does not always select the correct
region due to the blank areas, so the macro selects the named area first.

I went with Andy's suggestion in the end.