View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Joe Joe is offline
external usenet poster
 
Posts: 476
Default Advanced Filter using a range name as the criteria

I am running a macro and want to select records from a database that are
within a date range that the macro prompts for.
So macro gets STARTDATE and ENDDATE and has stored them in a date formatted
field.
STARTDATE=1/3/2008 and ENDATE=1/5/2008
The database is
Event Date Event Name
1/1/2008 Event 1
1/3/2008 Event 2
1/5/2008 Event 3
1/7/2008 Event 4

What is the criteria to use? I have tried "everything" but must have done
something wrong.