Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Perplexed
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. |