Sorting based on range names help needed

[afriendtln]

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

 

[bjwillingham]

Set rid of the Range().select code

Range("yourdatarangename") replaces Selection in the sort code, as follows:

Range("yourdatarangename").Sort Key1:=Range("L5"), Order1:=xlDescending, Key2:=Range("S5") _
, Order2:=xlDescending, Header:=xlGuess, OrderCustom:=1, MatchCase:= _
False, Orientation:=xlTopToBottom

 

[afriendtln]

Thanks for the help!