I am running Excel 2000. I have posted variations of this question off and
on for several weeks and no one has offered a workable soulution. Here is a
simple code:

Dim Srt As Range
Set Srt = Sheets("Code").Range("P2")
Selection.AutoFilter Field:=7, Criteria1:=Srt

Field 7 ties to a column of data filled with dates. Range P2 is one of
those dates. The data filters but everything is hiden??? If I change one
value in field seven to text instead of a date (say the word Joe) and change
Rane P2 to ("Joe") then the table autofilters and displays the data filtered
by the Joe criteria.

I am perplexed. Why won't this code work correctly with a date? How can I
fix this. I need this to work badly.