Results 1 to 16 of 16

Sort is not working as I was expecting

Threaded View

iscar_marius Sort is not working as I was... 06-23-2012, 05:21 PM
martindwilson Re: Sort is not working as I... 06-23-2012, 06:00 PM
Cutter Re: Sort is not working as I... 06-23-2012, 06:45 PM
jeffreybrown Re: Sort is not working as I... 06-23-2012, 08:53 PM
jaslake Re: Sort is not working as I... 06-23-2012, 09:19 PM
Cutter Re: Sort is not working as I... 06-23-2012, 09:27 PM
jaslake Re: Sort is not working as I... 06-23-2012, 09:36 PM
Cutter Re: Sort is not working as I... 06-23-2012, 09:46 PM
jaslake Re: Sort is not working as I... 06-23-2012, 10:08 PM
jeffreybrown Re: Sort is not working as I... 06-23-2012, 09:56 PM
jaslake Re: Sort is not working as I... 06-23-2012, 10:20 PM
jeffreybrown Re: Sort is not working as I... 06-23-2012, 10:25 PM
jaslake Re: Sort is not working as I... 06-23-2012, 11:13 PM
martindwilson Re: Sort is not working as I... 06-24-2012, 03:59 AM
iscar_marius Re: Sort is not working as I... 06-24-2012, 06:09 AM
Cutter Re: Sort is not working as I... 06-24-2012, 07:17 AM
  1. #1
    Forum Contributor iscar_marius's Avatar
    Join Date
    12-19-2008
    Location
    germany
    MS-Off Ver
    2000 and 2003
    Posts
    221

    Sort is not working as I was expecting

    I tried to use below code:

              Worksheets("Input").Range(Cells(17, 1), Cells(number_row, 8)).Sort _
                Key1:=Worksheets("Input").Range("A17")
    to sort this kind of data:

    test1
    test2
    ....
    test10
    test11
    ...

    The result is like this:
    test1
    test10
    test11
    test2
    ...


    But I need :
    test1
    test2
    ....

    How can I do this with sort?
    Thank you.
    Last edited by iscar_marius; 06-24-2012 at 06:10 AM.

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