Thread: use variable in macro for date

Hi, I have a macro that I must change about 10 dates in as it autofilters by date in certain columns like this..

Selection.AutoFilter Field:=7, Criteria1:=">10/15/2010", Operator:=xlAnd, _
Criteria2:="<10/22/2010"


Is there a way to make criteria 1 use todays date, and criteria 2 use todays date + 7 days ?
do i need to use a variable for the system date ?

Not tested:

Like this:

Selection.AutoFilter Field:=7, Criteria1:=> Date, Operator:=xlAnd, _
Criteria2:=< Date +7

Microsoft Office Help - Excel VBA Programming

Originally Posted by vsantoro

Thanks, Excel knows +7 means plus 7 days ? not 7 years, or 7 months ?

Yes, Excel works in days,
7 days = 1 week
365 days = 1 year....etc

You may have to do this with the greater/less than signs:
Criteria:=">" & Date...etc