Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
2-column sort macro
Hi again, you guys were so great at answering my last question that thought I'd pose another. (That, and I can't for the life of me figur it out.) A two-column sort obviously works when done manually, and I can eve record a working version as a macro- but as soon as you try to run it it messes up. Here's the code I'm using, please advise: Range("A13:V19").Select Selection.Sort Key1:=Range("V13"), Order1:=xlDescending Key2:=Range( _ "G13"), Order2:=xlDescending, Header:=xlGuess, OrderCustom:=1 MatchCase _ :=False, Orientation:=xlTopToBottom End Su -- rmcveig ----------------------------------------------------------------------- rmcveigh's Profile: http://www.excelforum.com/member.php...fo&userid=3735 View this thread: http://www.excelforum.com/showthread.php?threadid=57219 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
2-column sort macro
Aside from the line wrap problems, the code looks ok to me.
What does "messes up" mean? rmcveigh wrote: Hi again, you guys were so great at answering my last question that I thought I'd pose another. (That, and I can't for the life of me figure it out.) A two-column sort obviously works when done manually, and I can even record a working version as a macro- but as soon as you try to run it, it messes up. Here's the code I'm using, please advise: Range("A13:V19").Select Selection.Sort Key1:=Range("V13"), Order1:=xlDescending, Key2:=Range( _ "G13"), Order2:=xlDescending, Header:=xlGuess, OrderCustom:=1, MatchCase _ :=False, Orientation:=xlTopToBottom End Sub -- rmcveigh ------------------------------------------------------------------------ rmcveigh's Profile: http://www.excelforum.com/member.php...o&userid=37353 View this thread: http://www.excelforum.com/showthread...hreadid=572198 -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
2-column sort macro
The macro looks sound and that approach certainly works.
Possibly you have a data problem. Define messes up. -- Regards, Tom Ogilvy "rmcveigh" wrote: Hi again, you guys were so great at answering my last question that I thought I'd pose another. (That, and I can't for the life of me figure it out.) A two-column sort obviously works when done manually, and I can even record a working version as a macro- but as soon as you try to run it, it messes up. Here's the code I'm using, please advise: Range("A13:V19").Select Selection.Sort Key1:=Range("V13"), Order1:=xlDescending, Key2:=Range( _ "G13"), Order2:=xlDescending, Header:=xlGuess, OrderCustom:=1, MatchCase _ :=False, Orientation:=xlTopToBottom End Sub -- rmcveigh ------------------------------------------------------------------------ rmcveigh's Profile: http://www.excelforum.com/member.php...o&userid=37353 View this thread: http://www.excelforum.com/showthread...hreadid=572198 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use macro to sort column | Excel Worksheet Functions | |||
Auto-Sort Won't Sort All Column Cells | Excel Discussion (Misc queries) | |||
Macro To Sort By Column Header Names | Excel Worksheet Functions | |||
data, sort option is grayed. how to sort on a column? | Excel Discussion (Misc queries) | |||
Can someone give me a simple macro to sort a column? | Excel Programming |