Perplexed

[Guest]

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.

 

[Tushar Mehta]

Does field 7 have a date or a date-and-time? How about cell P2?

Click in a cell in field 7 then in P2 and change the format to
'General.' What do you see in the cell/formula bar?

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Alan Beban]

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.

Sounds like it already does

Alan Beban

 

[Guest]

Both are formatted to date mm/dd/yy. When I click either I would see i.e.
04/15/2003