This documentation is archived and is not being maintained.

Table.SortDescending Method

Office 2007
Sorts table rows in descending alphanumeric order.



expression   Required. A variable that represents a Table object.


The first table row is considered a header record and isn't included in the sort. Use the Sort method to include the header record in a sort.

This method offers a simplified form of sorting intended for mail-merge data sources that contain columns of data. For most sorting tasks, use the Sort method.


This example creates a 5x5 table in a new document, inserts text into each cell, and then sorts the table in descending alphanumeric order.

Visual Basic for Applications
Set newDoc = Documents.Add
Set myTable = _
    newDoc.Tables.Add(Range:=Selection.Range, NumRows:=5, _
For iRow = 1 To myTable.Rows.Count
    For iCol = 1 To myTable.Columns.Count
        Set MyRange = myTable.Rows(iRow).Cells(iCol).Range
        MyRange.InsertAfter "Cell" & Str$(iRow) & "," & Str$(iCol)
    Next iCol
Next iRow
MsgBox "Click OK to sort in descending order."

This example sorts the table that contains the insertion point in descending alphanumeric order.

Visual Basic for Applications
If Selection.Information(wdWithInTable) = True Then 
    MsgBox "The insertion point is not in a table."
End If