"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.