+ Reply to Thread
Results 1 to 4 of 4

.AutoFilter compatibility between Excel 2007 & Later versions when dates are involved

  1. #1
    Forum Contributor
    Join Date
    09-07-2010
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    358

    .AutoFilter compatibility between Excel 2007 & Later versions when dates are involved

    Hi,

    I have a macro that I am using that is 5+ years old, I first started using it in 32bit Excel 2007 but I no longer use Excel 2007 anymore, instead I use Excel 2013 and this macro no longer works correctly...

    • Run it in Excel 2007 with regional settings set to United Kingdom or United States = Works perfectly
    • Run it in Excel 2010 or Excel 2013 with regional settings set to United Kingdom = Doesn't work
    • Run it in Excel 2010 or Excel 2013 with regional settings set to United States = Works perfectly

    Problem is, I'm British so my regional settings are set to United Kingdom.

    How can I make my macro compatible so that it can either manage with any of the regional settings OR how can I get the macro to only work with United Kingdom regional settings (date)...

    The macro is supposed to match two columns using autofilters to find the matched rows and then export data from one sheet to a different sheet. I've included a sheet called "RUSHEET (CORRECT)" that has what the output should look like.

    The macro in question is:

    Please Login or Register  to view this content.

    You can download the file either from my dropbox or use the attached file.

    https://www.dropbox.com/s/8edbk8rcp3...mple.xlsm?dl=1
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: .AutoFilter compatibility between Excel 2007 & Later versions when dates are involved

    Hyflex,
    Try to change these lines

    Please Login or Register  to view this content.
    Remove the error line- On Error Resume Next
    Last edited by AB33; 02-24-2015 at 05:37 AM.

  3. #3
    Forum Contributor
    Join Date
    09-07-2010
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    358

    Re: .AutoFilter compatibility between Excel 2007 & Later versions when dates are involved

    AB33, that worked.. what did you do to do that? Has that turned the date into text?

  4. #4
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: .AutoFilter compatibility between Excel 2007 & Later versions when dates are involved

    No, it is the correct syntax, if you the criterion is in a different sheet (Column).
    Last edited by AB33; 02-24-2015 at 11:02 AM.

+ 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. Compatibility of Excel 2010 with prior versions
    By oscarm in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-01-2013, 12:29 PM
  2. Excel 2007 : Autofilter - 2003 vs 2007 compatibility
    By Cheshire in forum Excel General
    Replies: 0
    Last Post: 12-19-2008, 03:31 PM
  3. Compatibility problems between Excel 2003 SP3 and earlier versions
    By mooro007 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-28-2007, 09:45 AM
  4. [SOLVED] A question on VBA compatibility between versions of Excel.
    By John Thomas in forum Excel General
    Replies: 7
    Last Post: 02-10-2006, 09:10 PM
  5. Excel 2002 compatibility with earlier versions
    By tomhelle in forum Excel General
    Replies: 1
    Last Post: 04-26-2005, 10:06 AM

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