SortField.Order (Excel)

Determines the sort order for the values specified in the key. Possible return values are xlAscending - Sorts the specified field in ascending order. This is the default value, xlDescending - Sorts the specified field in descending order.

ActiveSheet.Sort.SortFields(1).Order = xlAscending