I am using Excel 97.

I have a worksheet of data with read-only access which has a column with a
formatted column of dd-mmm-yy (by another department!). I am trying to
filter it with VBA.

I have done the following but failing to get the required information
returned!

dim StartDate as date

Selection.AutoFilter
Selection.AutoFilter Field:=2, Criteria1:="=" & StartDate & "", Operator:= _
xlAnd

Can someone offer me a workaround, please?

--
Mark