Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |