With ActiveSheet.Range("A2:E137")
.Cells.Sort key1:=.Columns(1), order1:=xlAscending, Header:=xlNo, _
MatchCase:=False, Orientation:=xlTopToBottom
End With

Check if the header argument is correct.


XP wrote:

Using Office 2007 and Win XP;

I recorded a macro to sort a range and I got some gobblety-gook that doesn't
run when I replay the macro.

In my code, I first select a range (e.g. A2:E137) then I want to sort on
column "A".

Can someone please post a generic code example that would do this (Office
2007)?

Thanks much in advance.

--

Dave Peterson