Table.Sort Method (Word)
Sorts the specified table.
Syntax
expression .Sort(ExcludeHeader, FieldNumber, SortFieldType, SortOrder, FieldNumber2, SortFieldType2, SortOrder2, FieldNumber3, SortFieldType3, SortOrder3, CaseSensitive, BidiSort, IgnoreThe, IgnoreKashida, IgnoreDiacritics, IgnoreHe, LanguageID)
expression Required. A variable that represents a Table object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
ExcludeHeader |
Optional |
Variant |
True to exclude the first row from the sort operation. The default value is False. |
FieldNumber |
Optional |
Variant |
The first field by which to sort. Microsoft Word sorts by FieldNumber, then by FieldNumber2, and then by FieldNumber3. |
SortFieldType |
Optional |
Variant |
The sort type for FieldNumber. Can be one of the WdSortFieldType constants. Some of these constants may not be available to you, depending on the language support (U.S. English, for example) that you have selected or installed. The default value is wdSortFieldAlphanumeric. |
SortOrder |
Optional |
Variant |
The sorting order to use when sorting FieldNumber. Can be a WdSortOrder constant. |
FieldNumber2 |
Optional |
Variant |
The second field by which to sort. |
SortFieldType2 |
Optional |
Variant |
The sort type for FieldNumber2. Can be one of the WdSortFieldType constants. Some of these constants may not be available to you, depending on the language support (U.S. English, for example) that you have selected or installed. The default value is wdSortFieldAlphanumeric. |
SortOrder2 |
Optional |
Variant |
The sorting order to use when sorting FieldNumber2. Can be one WdSortOrder constant. |
FieldNumber3 |
Optional |
Variant |
The third field by which to sort. |
SortFieldType3 |
Optional |
Variant |
The sort type for FieldNumber3. Can be one of the WdSortFieldType constants. Some of these constants may not be available to you, depending on the language support (U.S. English, for example) that you have selected or installed. The default value is wdSortFieldAlphanumeric. |
SortOrder3 |
Optional |
Variant |
The sorting order to use when sorting FieldNumber3. Can be one WdSortOrder constant. |
CaseSensitive |
Optional |
Variant |
True to sort with case sensitivity. The default value is False. |
BidiSort |
Optional |
Variant |
True to sort based on right-to-left language rules. This argument may not be available to you, depending on the language support (U.S. English, for example) that you’ve selected or installed. |
IgnoreThe |
Optional |
Variant |
True to ignore the Arabic character alef lam when sorting right-to-left language text. This argument may not be available to you, depending on the language support (U.S. English, for example) that you’ve selected or installed. |
IgnoreKashida |
Optional |
Variant |
True to ignore kashidas when sorting right-to-left language text. This argument may not be available to you, depending on the language support (U.S. English, for example) that you’ve selected or installed. |
IgnoreDiacritics |
Optional |
Variant |
True to ignore bidirectional control characters when sorting right-to-left language text. This argument may not be available to you, depending on the language support (U.S. English, for example) that you’ve selected or installed. |
IgnoreHe |
Optional |
Variant |
True to ignore the Hebrew character he when sorting right-to-left language text. This argument may not be available to you, depending on the language support (U.S. English, for example) that you’ve selected or installed. |
LanguageID |
Optional |
Variant |
Specifies the sorting language. Can be one of the WdLanguageID constants. Refer to the Object Browser for a list of the WdLanguageID constants. |
Example
This example sorts the first table in the active document, excluding the heading row.
Sub NewTableSort()
ActiveDocument.Tables(1).Sort ExcludeHeader:=True
End Sub