Headers Sort With Data

**kwengerd** · 08-27-2012, 03:33 PM

I'm stumped with this occasionally. Everything was working fine then suddenly, my column headers start sorting with the data. What's up? There are no columns without headers and are all text.

**xladept** · 08-27-2012, 05:08 PM

Hi kwengerd,

You've got to let it know that there are headers:

Please Login or Register  to view this content.

**kwengerd** · 08-28-2012, 09:59 AM

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.

**kwengerd** · 08-28-2012, 10:13 AM

Figured it out: The checkbox in the sort dialog was unchecked (for some unknown reason

). Re-checking it solved the issue.

**Cutter** · 08-28-2012, 12:29 PM

@ kwengerd

Based on your last post it seems that you solved your issue on your own but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.