Filtering dates

[JasperD]

Hi guys,

I'm trying to filter dates through VBA.
Macro recorder gives me this:

Please Login or Register  to view this content.

If I apply that like this, it won't work. It errors out. It does apply a filter with no results if I change Criteria2 to Criteria1.

Please Login or Register  to view this content.

arr is a string that is as below:
2, "7/18/2015", 2, "7/25/2015", 2, "8/1/2015", 2, "8/8/2015", 2, "8/15/2015", 2, "8/22/2015", 2, "8/29/2015", 2, "9/5/2015"

What am I doing wrong?

[JasperD]

Really... Noone.....?

[AB33]

Hi Jasper,
What is criteria 2?
Should be criteria 1 and in front of the array.
Like

Please Login or Register  to view this content.

If you have a vertical data, you need to use transpose them

Please Login or Register  to view this content.

[JasperD]

Hi AB33,

thanks for your reply - I was also wondering why the macro recorder comes up with Criteria2 - but it works when recorded. Just when trying to replicate it, it wouldn't.
And how do you mean vertical data? It's data per cell, right? Would I still need to transpose?

Thanks,

Jasper

[AB33]

A1:A10 is vertical A1:B1 is horizontal.
It could be there is no match for the filter criteria as you have spaces in your array. If the data are in a range, load the range in to an array and filter the array or set the data as a range.
One of these lines

Please Login or Register  to view this content.

[JasperD]

Hi AB33,

sorry for the late reply - your simple solution of picking up the 'arr' as below works fine.
Final code:

Please Login or Register  to view this content.

Thanks for your help!