_QueryTable.Sort Property
Returns the sort criteria for the query table range. Read-only.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
ReadOnly Property Sort As Sort
Get
'Usage
Dim instance As _QueryTable
Dim value As Sort
value = instance.Sort
Sort Sort { get; }
Property Value
Type: Microsoft.Office.Interop.Excel.Sort
Sort
Remarks
If you import data using the user interface, data from Web queries or text queries is imported as a _QueryTable object, while all other external data is imported as a ListObject object.
If you import data using the object model, data from Web queries or text queries must be imported as a QueryTable, while all other external data can be imported as either a ListObject or a QueryTable.
You can use the QueryTable property of the ListObject to access the Sort property.