use variable in macro for date

**vsantoro** · 10-26-2010, 09:37 AM

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 ?

**Simon Lloyd** · 10-26-2010, 09:49 AM

Not tested:

Like this:

Please Login or Register  to view this content.

Microsoft Office Help - Excel VBA Programming

**vsantoro** · 10-26-2010, 10:00 AM

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

**Simon Lloyd** · 10-26-2010, 10:23 AM

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