+ Reply to Thread
Results 1 to 3 of 3

Problem with sorting

  1. #1
    Registered User
    Join Date
    05-22-2012
    Location
    Malta
    MS-Off Ver
    Excel 2007
    Posts
    2

    Problem with sorting

    Hello, so I need to sort some values within an array and whenever I hit Run, Excel stops responding. I have a feeling that the problem has to do with a mistake in a loop but I cannot find it. Can any one help please? W10 - A1.xlsm

  2. #2
    Forum Contributor
    Join Date
    05-04-2012
    Location
    Stamford,Connecticut,USA
    MS-Off Ver
    Excel 2003
    Posts
    105

    Re: Problem with sorting

    Your loop in the sub Ascendingshear should be Do Until i>=m not just > m

  3. #3
    Registered User
    Join Date
    05-22-2012
    Location
    Malta
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Problem with sorting

    Well the program works now but instead of sorting the values in ascending order they are all given the value of the smallest one.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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