Key1 - Optional -Variant
Specifies the first sort field, either as a range name (String) or Range object; determines the values to be sorted.
Order1-Optional-XlSortOrder
Determines the sort order for the values specified in Key1.
Key2-Optional-Variant
Second sort field; cannot be used when sorting a pivot table.
Type-Optional-Variant
Specified which elements are to be sorted.
Order2-Optional-XlSortOrder
Determines the sort order for the values specified in Key2.
Key3-Optional-Variant
Third sort field; cannot be used when sorting a pivot table.
Order3-Optional-XlSortOrder
Determines the sort order for the values specified in Key3.
Header-Optional-XlYesNoGuess
Specifies whether the first row contains header information. xlNo is the default value; specify xlGuess if you want Excel to attempt to determine the header.
OrderCustom-Optional-Variant
Specifies a one-based integer offset into the list of custom sort orders.
MatchCase-Optional-Variant
Set to True to perform a case-sensitive sort, False to perform non-case sensitive sort; cannot be used with pivot tables.
Orientation-Optional-XlSortOrientation
Specifies if the sort should be in acending or decending order.
SortMethod-Optional-XlSortMethod
Specifies the sort method.
DataOption1-Optional-XlSortDataOption
Specifies how to sort text in the range specified in Key1; does not apply to pivot table sorting.
DataOption2-Optional-XlSortDataOption
Specifies how to sort text in the range specified in Key2; does not apply to pivot table sorting.
DataOption3-Optional XlSortDataOption
Specifies how to sort text in the range specified in Key3; does not apply to pivot table sorting.
Partager