+ Reply to Thread
Results 1 to 3 of 3

VBA Filter data betwen start date and end date doesn't run on MS.Excel 2013

  1. #1
    Registered User
    Join Date
    03-06-2014
    Location
    HCM
    MS-Off Ver
    Excel 2016
    Posts
    30

    VBA Filter data betwen start date and end date doesn't run on MS.Excel 2013

    Hy guys, I have an excel file coding vba to filter data values betwen start date and end date. I tested it on MS.Excel 2007, it ran ok but when I try it on MS.Excel higher version such as MS.Excel 2010 and MS.Excel 2013, filtered data values is empty. I also try format date for data value, but it seem be not impossible.
    Does everyone helps me solving it?
    Thanks
    Attached Files Attached Files

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

    Re: VBA Filter data betwen start date and end date doesn't run on MS.Excel 2013

    One way of getting around with dates.

    Please Login or Register  to view this content.
    Last edited by AB33; 03-26-2017 at 06:06 AM.

  3. #3
    Registered User
    Join Date
    03-06-2014
    Location
    HCM
    MS-Off Ver
    Excel 2016
    Posts
    30

    Re: VBA Filter data betwen start date and end date doesn't run on MS.Excel 2013

    THanks you so much AB33, I tested it runs good.

+ 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. Excel 2013 - if date is found between date range return value
    By theshybutterfly in forum Excel General
    Replies: 4
    Last Post: 12-11-2016, 01:14 AM
  2. How to extract data from another worksheet based on Start Date, End Date
    By xBadBoi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-18-2016, 03:20 PM
  3. Counting if data falls on date between Start Date, End Date or Possible End Date
    By JessHasQuestions in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 07-26-2014, 08:01 AM
  4. [SOLVED] Data Validation won't accept Start Date and End Date from cell values.
    By SpecialBrew in forum Excel General
    Replies: 12
    Last Post: 03-16-2014, 10:23 PM
  5. Replies: 0
    Last Post: 03-21-2013, 12:22 PM
  6. Replies: 1
    Last Post: 10-02-2012, 02:42 PM
  7. Replies: 4
    Last Post: 06-02-2012, 11:26 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