xlDescending is/has a value of 2, while xlAscending has a value of 1.Set a variable to 1 or 2 and use it in:... , Order1:=myVariable, ...