Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting Using Code
I have a data table A5:L3776 - Row 5 is header info
I need to enter code to sort this range Primary Sort on B Column Secondary Sort on G Column The Macro recorder is screwing things up. Can someone get me through this? TIA, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting Using Code
Range("A5:L3776").Sort Key1:=Range("B5"), _
Order1:=xlAscending, Key2:=Range("G5"), _ Order2:=xlAscending, Header:=xlYes, _ OrderCustom:=1, MatchCase:=False, _ Orientation:=xlTopToBottom -- Regards, Tom Ogilvy "Jim May" wrote in message news:FDrYc.22960$wu.18895@okepread04... I have a data table A5:L3776 - Row 5 is header info I need to enter code to sort this range Primary Sort on B Column Secondary Sort on G Column The Macro recorder is screwing things up. Can someone get me through this? TIA, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
code for sorting | Excel Discussion (Misc queries) | |||
Sorting in code | Excel Discussion (Misc queries) | |||
Sorting by code | Excel Discussion (Misc queries) | |||
sorting code | Excel Discussion (Misc queries) | |||
code for sorting | Excel Programming |