Thread: show all rows containing a date between x and y?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
aa aa is offline
external usenet poster
  
Posts: 3
Default show all rows containing a date between x and y?
Try this in your macro

Selection.AutoFilter Field:=1, Criteria1:="<date",
Operator:=xlAnd
Selection.AutoFilter Field:=2, Criteria1:="date",
Operator:=xlAnd

where the criteria will relate to a textbox1...

i.e.
criteria1:=<textbox1

may work!!!

Neo
Reply With QuoteReply With Quote