I'm facing a problem, I can't be able to sort a selected
range of data when I use this command in VB.Net.

Worksheet.UsedRange.Sort("A15",
XlSortOrder.xlAscending, "B15", ,
XlSortOrder.xlAscending, "C15", XlSortOrder.xlAscending,
XlYesNoGuess.xlYes, 1, False,
XlSortOrientation.xlSortColumns, XlSortMethod.xlPinYin)

is this command any wrong? please help me, thanks

Here is the argument list for the sort command (from xl2000).

expression.Sort(Key1, Order1, Key2, Type, Order2, Key3, Order3, Header,
OrderCustom, MatchCase, Orientation, SortMethod)

Notice that after the first key and order, there is a type variable which
you seem to have missed.



--

Regards,

Tom Ogilvy



"Chan Ho Seng" wrote in message
...
I'm facing a problem, I can't be able to sort a selected
range of data when I use this command in VB.Net.

Worksheet.UsedRange.Sort("A15",
XlSortOrder.xlAscending, "B15", ,
XlSortOrder.xlAscending, "C15", XlSortOrder.xlAscending,
XlYesNoGuess.xlYes, 1, False,
XlSortOrientation.xlSortColumns, XlSortMethod.xlPinYin)

is this command any wrong? please help me, thanks

Thanks for you replying for me, What should I put in that missed *Type
Variable

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

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/