afriendtln
New Member
- Joined
- Jan 12, 2005
- Messages
- 35
Is it possible to use range names to do a sort? see macro code below!
What syntax would I use to input the Range Name Data Sort in the place of B5.AS100?
Sheets("Project Prioritization Queue").Select
Range("B5:AS100").Select
Selection.Sort Key1:=Range("L5"), Order1:=xlDescending, Key2:=Range("S5") _
, Order2:=xlDescending, Header:=xlGuess, OrderCustom:=1, MatchCase:= _
False, Orientation:=xlTopToBottom
What syntax would I use to input the Range Name Data Sort in the place of B5.AS100?
Sheets("Project Prioritization Queue").Select
Range("B5:AS100").Select
Selection.Sort Key1:=Range("L5"), Order1:=xlDescending, Key2:=Range("S5") _
, Order2:=xlDescending, Header:=xlGuess, OrderCustom:=1, MatchCase:= _
False, Orientation:=xlTopToBottom