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


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements

This may do it:

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

--
Jim Rech
Excel MVP