Type Optional Variant. Specifies which elements are to be sorted. Can be
one of the following XlSortType constants: xlSortLabels or xlSortValues. Use
this argument only when sorting PivotTable reports.



Since you are not using named arguments you would at least need to use two
commas



Sort(key1,order1,,key2,order2, etc



--

Regards,

Tom Ogilvy

"Az Chan " wrote in message
...
Thanks for you replying for me, What should I put in that missed *Type*
Variable.


---
Message posted from http://www.ExcelForum.com/