Contains the index number of the first key sort order and specifies whether the data is sorted according to a built-in or custom-defined list of items, by the order of characters in the active code page, by syllabary, or by an East Asian language sort order.
Contained In
Remarks
This element can contain one of the following values:
Value | Description |
1 through 4 | Sort by one of the built-in lists. The value is an index to one of the available lists. |
5 or greater | Sort by a custom-defined list. The value is an index to one of the custom-defined lists. |
Or it can contain one of the following string constants:
Constant | Description |
xlCodePage | Sort by the order in the active code page. |
xlPinYin | Sort by Pin Yin order. This constant is used only when East Asian language support is installed and enabled. |
xlSyllabary | Sort by syllabary. |
xlStroke | Sort by character stroke. This element is used only when East Asian language support is installed and enabled. |
If Order is not specified, the normal sort order is used.
See the example in the Sorting element topic.