Sort a named range

[jmenche]

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

[matthewspatrick]

Can you post an example workbook?

[mdmackillop]

[VBA]Sub Sorts()
Range("Workload").Sort Key1:=Range("Workload").Cells(1), _
Order1:=xlAscending, Header:=xlGuess, OrderCustom:=1, _
MatchCase:=False, Orientation:=xlTopToBottom
End Sub
[/VBA]