+ Reply to Thread
Results 1 to 3 of 3

Macro not filtering between recognised dates

  1. #1
    Valued Forum Contributor
    Join Date
    01-16-2012
    Location
    England
    MS-Off Ver
    MS 365
    Posts
    1,397

    Macro not filtering between recognised dates

    Macro on attached should extract unique records from the DATABASE sheet that meet the four criteria on the MEASURE sheet

    It filters the database for the two criteria in D2 and D6 of the Measure sheet.
    It then recognises the MAXDATE and MINDATE in D10 and H10 of the Measure sheet, but is closing all the rows on the DATABASE sheet.

    Please Login or Register  to view this content.
    Hopefully someone can see the problem?

    All solutions and suggestions received gratefully as ever.

    Ochimus
    Attached Files Attached Files

  2. #2
    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,922

    Re: Macro not filtering between recognised dates

    When doing this in VBA it's best to convert the dates to a number:

    Please Login or Register  to view this content.
    but note that 31/06 is not a valid date!
    Rory

  3. #3
    Valued Forum Contributor
    Join Date
    01-16-2012
    Location
    England
    MS-Off Ver
    MS 365
    Posts
    1,397

    Re: Macro not filtering between recognised dates

    rorya,

    Many thanks for providing the solution so promptly, and apologies that three days of DEEP frustration led to such an obvious error with the June date..

    Ochimus

+ 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. Imported data dates recognised as numbers
    By IJY14 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-17-2018, 04:42 PM
  2. [SOLVED] Some dates not recognised accurately in excel
    By RuthieBuxton in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 07-27-2018, 09:21 AM
  3. Replies: 5
    Last Post: 10-19-2015, 10:56 AM
  4. [SOLVED] Dates recognised when recording Macro, but not recognised when running it.
    By Ochimus in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-21-2015, 10:19 AM
  5. [SOLVED] Dates copied from webpage not recognised by excel
    By juansn in forum Excel General
    Replies: 5
    Last Post: 11-08-2013, 06:36 AM
  6. [SOLVED] Help with filtering dates using a macro.
    By jcranst in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-28-2013, 08:40 AM
  7. Filtering between dates and time macro excel
    By elriverita in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-13-2012, 08:16 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