Sorting UsedRange of a Worksheet
How can I sort only the UsedRange of each Worksheet in a workbook? This is
what I have so far and it will not let me.
Sub Sort ()
For Each wks In Worksheets
wks.UsedRange.Sort Key1:=Range("L3"), Order1:=xlAscending, _
Key2:=Range("A3"), Order2:=xlAscending,
Header:=xlGuess
Next wks
End Sub
|