+ Reply to Thread
Results 1 to 7 of 7

Sort dynamic range alphabetically - cant get it working

  1. #1
    Registered User
    Join Date
    08-19-2012
    Location
    Germany
    MS-Off Ver
    Excel 2010
    Posts
    50

    Unhappy Sort dynamic range alphabetically - cant get it working

    Hello.
    I have a list of products that I want to sort by clicking on a button.
    I attached a sample book and here is the code with commentary.

    Please Login or Register  to view this content.
    Thanks a lot in advance!
    Attached Files Attached Files
    Last edited by Taktiker; 12-08-2013 at 11:35 AM.

  2. #2
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,376

    Re: Sort dynamic range alphabetically - cant get it working

    Hi Taktiker,
    maybe so
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    08-19-2012
    Location
    Germany
    MS-Off Ver
    Excel 2010
    Posts
    50

    Re: Sort dynamic range alphabetically - cant get it working

    This works in the sample book, but it misses a point I didnt mention. It should only sort the text entries until the first empty row. Because in the column is other data that shall not be sorted. This is the reason why I included the LastRow Variable.

  4. #4
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,376

    Re: Sort dynamic range alphabetically - cant get it working

    then maybe this
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    08-19-2012
    Location
    Germany
    MS-Off Ver
    Excel 2010
    Posts
    50

    Re: Sort dynamic range alphabetically - cant get it working

    I just noticed I that the macro has to sort 3 columns without changing the other columns, like e.g. the numbers on the left. I added some other cells to the sample book and marked the area to sort with a red border so you can visualize it more easily. Sorry for not telling you everything from the start.
    Attached Files Attached Files

  6. #6
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,376

    Re: Sort dynamic range alphabetically - cant get it working

    try again
    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    08-19-2012
    Location
    Germany
    MS-Off Ver
    Excel 2010
    Posts
    50

    Re: Sort dynamic range alphabetically - cant get it working

    Thanks a lot! This is exactly what I need.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Order / sort range by number in bracket first then remainder alphabetically.
    By skyping in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-25-2013, 08:14 AM
  2. How do I know if Dynamic Range is working?
    By livemusic in forum Excel General
    Replies: 9
    Last Post: 07-02-2011, 11:16 PM
  3. Excel 2007 : Sort a dynamic range alphabetically
    By lmsexcelforum in forum Excel General
    Replies: 2
    Last Post: 01-26-2009, 11:42 AM
  4. sort alphabetically and numerically, then sort rows
    By luke20allen in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-01-2008, 07:00 AM
  5. dynamic range - sort
    By sach0025 in forum Excel General
    Replies: 2
    Last Post: 02-02-2007, 05:14 PM

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