Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort current range by column j
After the following macro, I want to sort the selected range by column
J. Sub Macro1() Range("A100000").Select Selection.End(xlUp).Select Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlUp)).Select End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort current range by column j
On Oct 19, 10:09*pm, "J.W. Aldridge"
wrote: After the following macro, I want to sort the selected range by column use this: Selection.Sort Key1:=Range("J3"), Order1:=xlAscending, Header:=xlNo, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal good luck |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort by column, not range | Excel Discussion (Misc queries) | |||
Unable to sort when column is included in range | Excel Discussion (Misc queries) | |||
Sort a range of data based on another column | Excel Discussion (Misc queries) | |||
formula to sort a range so that it matches the exact rows of a column that is outside that range? | Excel Discussion (Misc queries) | |||
excel change default column sort to current selection | Excel Worksheet Functions |