Hi Jim,

Thank you very much, yes, I am preselecting an area based on a dynamic
named range which is also used to set the print area.
I think my problem with the ".show" was when I tried listing the
arguments was that I attempted to fill in the "sort_by, method" & not
just use a ", , " as spacers. I won't have a chance to experiment until
tomorrow but it looks like it will help tremendously :-)
Once I understand how to make the row headers appear in the form
(rather than the absolute addresses for the sort ranges). If I can't
figure it out I'll be in touch...

Once again thanks for your guidance,
Rob Brockett
NZ
Always learning & the best way to learn is to experience...


Jim Cone Wrote:
Hello Rob,

The Excel sort utility does not allow the user to change the selection
once the form is shown. It sorts the selection chosen before the
form is shown or uses the current region to sort... one or the other.
You as the code writer, of course, can select any range you want
before showing the form.
As far as the other options go...shown below is a crude example.
Experiment with it...substitute various values and see what you get...
'----------------------
'From the help file
'xlDialogSortSpecial sort_by, method, key1, order1, key2, order2, key3,
order3, header, order, case

Application.Dialogs(xlDialogSortSpecial).Show _
, , Range("B12"), xlDescending, Range("D12"), xlDescending,
Range("E12"), xlAscending, xlYes, xlTopToBottom, False
'----------------------
Regards,
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=501426