View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Oldjay Oldjay is offline
external usenet poster
 
Posts: 337
Default Filtering with criteria in an remote cell

I have a list of records in col B thru F.
I wish to filter based on a start date and end date. These dates are located
in cells O3 and O5. The dates are in col B

Range("B1:F1").Select ' This is the header
Selection.AutoFilter Field:=1, Criteria1:="==RANGE(""O3"")", Operator:= _
xlAnd, Criteria2:="<==RANGE(""O5"")

This filters out all records

Can anyone help?

oldjay