How to do filter in VBA for the last three days?
<p>I use VBA EXCEL and I need to to filter for row to the last 3 days.
For example: Today it's 02.11 and i dont want to see days 11.02, 10.02 and 09.02.</p>

<p>I tried to do this with the macro:</p>

<pre><code>ActiveSheet.Range("$A$1:$AB$11153").AutoFilter Field:=10, Operator:= _
    xlFilterValues, Criteria2:=Array(2, "1/12/2016", 2, "1/13/2016", 2, "1/17/2016", 2, _
    "1/18/2016", 2, "1/20/2016", 2, "1/21/2016", 2, "1/22/2016", 2, "1/23/2016", 0, _
    "12/21/2015")
</code></pre>

<p>but its for spastic days and i need the last three days?</p>