Conditional sort - ascending if sorted descending

[Magriza]

Hi Guys and Gals,

A quick question if I may:

Is it possible to have a macro that runs from one button to sort a range in ascending order AND descending order? Obviously not at the same time.

So: if column A is sorted ascendingly and then the button is pressed again, the macro would check the range - if it's sorted ascendingly already it will then reverse the order.

Many thanks for all the help!

 

[jimrward]

one suggestion would be to have a sentry value in another cell outwith the sort range, i would suggest you put the value 1 in the cell.

Create your button and macro to do the sort, add an IF statement around the sort code on the lines of

IF range("B1").value = 1 then
sort ascending
else
sort descending
end if
range("B1").value = range("B1").value * -1

this would change the sentry value between 1 and -1

 

[Magriza]

Hi jimrward,

Many thanks for your suggestion! I've incorporated it into my design and it works very well!

It also allows me to change my header based on the value assigned (1, 2 or nothing) to Heading ▲ or ▼ for ascending or descending using a standard if formula.

Sometimes I get too lost in the code that I forget you can use code in conjunction with cells! Thanks again for steering me to the right path.