+ Reply to Thread
Results 1 to 2 of 2

Sorting Macro From Office 2010 In Office 2003

  1. #1
    Registered User
    Join Date
    05-09-2012
    Location
    USA
    MS-Off Ver
    2019 16.0.13205.200000 64-bit
    Posts
    61

    Question Sorting Macro From Office 2010 In Office 2003

    Guys, I have an issue with a macro. Basically situation is the following, I developed a file in Excel 2010 for a user with Excel 2003. Everything seems to be fine, but one macro doesn't work in Office 2003 and I (of course) need it to work properly.

    The macros does the following: selects 4 columns of data, sorts it in descending order based on second column. That's pretty much it.
    Here's the code:
    Please Login or Register  to view this content.
    It breaks on this particular field:
    Please Login or Register  to view this content.
    So I assume Office 2003 has a problem of how the syntax was recorded in Office 2010. Could anyone be so kind to help me identify the issue and rewrite it so it works in 2003?


    I'd be most helpful for any help on the matter!


    P.S. Issue is similar to this post, but it wasn't answered there unfortunately.
    Last edited by splendidus; 06-27-2012 at 10:25 AM.
    Office 2019 16.0.13205.200000 64-bit

  2. #2
    Registered User
    Join Date
    05-09-2012
    Location
    USA
    MS-Off Ver
    2019 16.0.13205.200000 64-bit
    Posts
    61

    Thumbs up Re: Sorting Macro From Office 2010 In Office 2003

    Quote Originally Posted by splendidus View Post
    Guys, I have an issue with a macro. Basically situation is the following, I developed a file in Excel 2010 for a user with Excel 2003. Everything seems to be fine, but one macro doesn't work in Office 2003 and I (of course) need it to work properly.

    The macros does the following: selects 4 columns of data, sorts it in descending order based on second column. That's pretty much it.
    Here's the code:
    Please Login or Register  to view this content.
    It breaks on this particular field:
    Please Login or Register  to view this content.
    So I assume Office 2003 has a problem of how the syntax was recorded in Office 2010. Could anyone be so kind to help me identify the issue and rewrite it so it works in 2003?


    I'd be most helpful for any help on the matter!


    P.S. Issue is similar to this post, but it wasn't answered there unfortunately.
    For those interested, I managed to solve this thing myself, since I was lucky enough that I had a chance to lay my hands on a machine with Office 2003 up and running. Resulting code works fine both in Excel 2003 and Excel 2010.

    So here's a replacement code (for Excel 2003) for the original above (from 2010):
    Please Login or Register  to view this content.
    Data in formula:
    C5:F13 - complete data range, including headings
    D6 - first cell of data (below the heading = excluding the heading cell) of column by which sorting is done (second column after vertical data labels)
    Overall data description:
    C5:F5 - horizontal headings only
    C6:C13 - vertical data labels
    D6:F13 - data without headings

    Hope this helps somebody, because it sure as hell worked out for me
    Last edited by splendidus; 06-28-2012 at 05:04 AM.

+ 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