Hello,
Does anyone know how to set up a date in a Macro so that it allows me
to put in a date when I run the Macro. When I created the macro I
created it with a criteria for a September but at the end of month I
will need to capture the data for October and so on. Is there a way to
change the dates other than manually going into the macro every month
and changing them? Listed below is the structure of the dates using
the Macro recorder:

Selection.AutoFilter Field:=37, Criteria1:="=9/5/2005",
Operator:=xlAnd _
, Criteria2:="<=10/2/2005"

How should I change the code so that it look at a new set of dates
every month?

Any help is appreciated.


--
Lizz45ie
------------------------------------------------------------------------
Lizz45ie's Profile: http://www.excelforum.com/member.php...o&userid=23410
View this thread: http://www.excelforum.com/showthread...hreadid=479917