SortField.DataOption (Excel)

Specifies how to sort text in the range specified in a SortField object. Possible return values are xlSortNormal - default. Sorts numeric and text data separately, xlSortTextAsNumbers - Treat text as numeric data for the sort.

XlSortDataOption can be either xlSortNormal or xlSortTextAsNumbers.

ActiveSheet.Sort.SortFields(1).DataOption = xlSortNormal