This documentation is archived and is not being maintained.

XlSortDataOption Enumeration 

Specifies how to sort text.

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in

Dim xlSortDataOption1 As XlSortDataOption = XlSortDataOption.xlSortNormal

public enum XlSortDataOption
public enum XlSortDataOption
public enum XlSortDataOption

Member nameDescription
xlSortNormaldefault. Sorts numeric and text data separately.
xlSortTextAsNumbersTreat text as numeric data for the sort.

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms