autofilter not working correct for date

  • Hi

    I have a data worksheet and am using autofilter vba code. I have the following criteria:

    I have the above code but when i search for the date it always picks up the first date regardless but the rest of the filter is fine.

    not sure why this is happening?

    can someone please help

    i have attached file. Data is the tab where the data is held. Masterproject has the filter button

  • Re: autofilter not working correct for date

    Hello tjsingh,

    Welcome to Ozgrid.

    All VBA code posted to the forum must be wrapped in code tags, which you omitted. I've added the tags for you this time only. Please be sure to use them in future posts.

    How to use code tags: [noparse]

    your code here


    There is no attachment.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!