Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sorting a large selection
hello, this is my first time posting so excuse me if i do anythig wrong i would like some help on a script for sorting a large selection o numerical data in ascending order the range of the selection would be the whole column (i.e. i woul click the A if i wanted to sort the A column, but the script shoul also work for sorting out other columns) for example i have data that is 10/12312/123312/231/1232 24/12312/123312/231/1230 46/12312/123312/231/1233 57/12312/123312/231/1235 99/12312/123312/231/1234 13210/12312/123312/231/121223 appreciate the hel -- narutar ----------------------------------------------------------------------- narutard's Profile: http://www.excelforum.com/member.php...fo&userid=2511 View this thread: http://www.excelforum.com/showthread.php?threadid=38616 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
sorting a large selection
Selection.Sort Key1:=selection(1), Order:=xlAscending
Excel will allow you to specify 3 key columns at a time. If you need more, then you need to work for the lowest level of significance up to the highest level of significance in groups of 3. You can get most of this by Turning on the macro recorder and doing it manually once. then generalize the code. -- Regards, Tom Ogilvy "narutard" wrote in message ... hello, this is my first time posting so excuse me if i do anythign wrong i would like some help on a script for sorting a large selection of numerical data in ascending order the range of the selection would be the whole column (i.e. i would click the A if i wanted to sort the A column, but the script should also work for sorting out other columns) for example i have data that is 10/12312/123312/231/1232 24/12312/123312/231/1230 46/12312/123312/231/1233 57/12312/123312/231/1235 99/12312/123312/231/1234 13210/12312/123312/231/121223 appreciate the help -- narutard ------------------------------------------------------------------------ narutard's Profile: http://www.excelforum.com/member.php...o&userid=25111 View this thread: http://www.excelforum.com/showthread...hreadid=386163 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fill last row down for large selection? | Excel Worksheet Functions | |||
Selection Too Large | Excel Discussion (Misc queries) | |||
why does sorting large columns create errors in top selection? | Excel Worksheet Functions | |||
Selection Too Large | Excel Programming | |||
Selection is too large | Excel Programming |