PDA

View Full Version : Sort a named range



jmenche
03-15-2006, 07:28 AM
Howdy,

I am having a problem sorting a dynamic named range in VBA. I don't know if it's just a syntax error or something far more sinister. If I have a dynamic range named "Workload" in a sheet named "Analytic Workload", can somebody show me a macro to sort it?

Thanks :beerchug:

matthewspatrick
03-15-2006, 07:45 AM
Can you post an example workbook?

mdmackillop
03-15-2006, 02:30 PM
Sub Sorts()
Range("Workload").Sort Key1:=Range("Workload").Cells(1), _
Order1:=xlAscending, Header:=xlGuess, OrderCustom:=1, _
MatchCase:=False, Orientation:=xlTopToBottom
End Sub