| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
toggle sort columns
I have a button linked to a macro that will sort a data ascending. Is there
a way to click said button a second time and it will sord descending? Here's the code thus far: Sub sort_date() Range("A3:T23").Sort Key1:=Range("G3"), Order1:=xlAscending, Header:= _ xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort by color: Is there an easy way to sort columns or rows in EX | Excel Worksheet Functions | |||
| sort by two columns ends up with wrong sort in 2nd col | Excel Discussion (Misc queries) | |||
| Sort command does not sort some columns? | New Users to Excel | |||
| How do I sort the data in 8 columns by two of the columns? | Excel Worksheet Functions | |||
| data sort is not including all columns in sort | Excel Discussion (Misc queries) | |||
Threaded Mode
