Sort a named range

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:

Can you post an example workbook?

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