Sort not working now...

[ChrisXcel]

I had sorting code that was working before, but not now.
Can anyone please see if anything is wrong with this sort code?

Please Login or Register  to view this content.

Thanks!

Rows are being sorted like this now:

ColumnA

BBB ...
AAA ...
BBB ...
BBB ...

[shg]

Where does your data start? Is there a header, and if so, what row?

[ChrisXcel]

Where does your data start? Is there a header, and if so, what row?

My data is inside my named range $A$20:$K$29.
There is no header in this range.

I just recorded a macro for sorting the range and saw a few things.
First, the sorting was defaulting to a header, so I changed it to no header.
Then it sorted properly. I will change my code to the following and try it again:

'Selection.Sort Key1:=Range("A20"), Order1:=xlAscending, Header:=xlNo, _

[shg]

Please Login or Register  to view this content.

[ChrisXcel]

Please Login or Register  to view this content.

Thanks very much shg, your code is the simplest (and it works), so I will go with it.

[shg]

You're welcome.