+ Reply to Thread
Results 1 to 4 of 4

Sort problem with older versions of excel

  1. 07-14-2020, 02:33 PM #1
    scrabtree23
    scrabtree23 is offline
    Forum Contributor
    Join Date
    07-27-2012
    Location
    Somerset, Kentucky
    MS-Off Ver
    Excel 2007
    Posts
    123

    Sort problem with older versions of excel

    I recorded a sort macro in excel (Office 365). When I shared it, those with Office 2010, the macro gives a run time error. Please help.


    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 07-14-2020, 02:36 PM #2
    rorya
    rorya is offline
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,911

    Re: Sort problem with older versions of excel

    Use Add not Add2 for backward compatibility.
    Rory
    Reply With QuoteRegister To Reply
  3. 07-14-2020, 03:44 PM #3
    scrabtree23
    scrabtree23 is offline
    Forum Contributor
    Join Date
    07-27-2012
    Location
    Somerset, Kentucky
    MS-Off Ver
    Excel 2007
    Posts
    123

    Re: Sort problem with older versions of excel

    Quote Originally Posted by rorya View Post
    Use Add not Add2 for backward compatibility.
    Thank you.
    Reply With QuoteRegister To Reply
  4. 07-14-2020, 03:55 PM #4
    Vraag en antwoord
    Vraag en antwoord is offline
    Valued Forum Contributor
    Join Date
    04-01-2015
    Location
    The Netherlands
    MS-Off Ver
    2003/2007/2010/2016/office 365
    Posts
    880

    Re: Sort problem with older versions of excel

    Use the .range.sort method

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. MinIFS() for older versions of excel help.
    By MarvinP in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 08-31-2020, 01:09 AM
  2. Simulating conditions of older Excel versions
    By chengafni in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-29-2016, 10:21 AM
  3. Drop-down lists in older versions of Excel
    By nclark52 in forum Excel General
    Replies: 1
    Last Post: 09-29-2015, 05:52 PM
  4. Problems opening older versions of Excel spreadsheets
    By OM2 in forum Excel General
    Replies: 1
    Last Post: 01-23-2013, 08:03 PM
  5. [SOLVED] How can I verify that an Excel file will work with older versions
    By Tony English in forum Excel General
    Replies: 3
    Last Post: 01-30-2006, 11:00 AM
  6. [SOLVED] Using Older versions of ms excel with 2003
    By BassJay in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-18-2005, 02:05 PM
  7. Older versions of Excel
    By Jaygirl44 in forum Excel General
    Replies: 0
    Last Post: 05-13-2005, 06:21 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1