Hi kwengerd,
You've got to let it know that there are headers:
![]()
Sort Key1:=Range("A1"), Order1:=xlAscending, Header:=xlYes
Hi kwengerd,
You've got to let it know that there are headers:
![]()
Sort Key1:=Range("A1"), Order1:=xlAscending, Header:=xlYes
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
I'm not even sorting using VBA. I'm simply placing my cursor in the column to sort and it now mixes the header in with the data block. It didn't do this before but now suddenly does.
Figured it out: The checkbox in the sort dialog was unchecked (for some unknown reason). Re-checking it solved the issue.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks