View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
rmcveigh[_5_] rmcveigh[_5_] is offline
external usenet poster
 
Posts: 1
Default 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