Help with my first macro please

[debbie]

I have the following in my first macro:

Selection.AutoFilter Field:=2, Criteria1:=">20-Nov",
Operator:=xlAnd
Range("C11:C214").Select

which works fine. However, what i would like is for the date to change
to today whenever I run it. At the moment I have to update it
manually.

Does anyone know how I can do this?

Many thanks in advance

Debbie

 

[Jim Rech]

This may do it:

Selection.AutoFilter Field:=2, Criteria1:=">" & Int(Now)