+ Reply to Thread
Results 1 to 5 of 5

Headers Sort With Data

Hybrid View

  1. #1
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Headers Sort With Data

    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

  2. #2
    Registered User
    Join Date
    06-24-2011
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: Headers Sort With Data

    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.

  3. #3
    Registered User
    Join Date
    06-24-2011
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: Headers Sort With Data

    Figured it out: The checkbox in the sort dialog was unchecked (for some unknown reason ). Re-checking it solved the issue.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1