Sort not working now...

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

Originally Posted by shg

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, _

Please Login or Register  to view this content.

You're welcome.