How to soft a selected range of data in Excel by using VB.Net

C

Chan Ho Seng

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
 
T

Tom Ogilvy

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

Tom Ogilvy

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
 
Top