Using "AND" operator in EXCEL function

[grierfield]

I am trying to select the “VRE” within the dates Below – but I cant get the “AND” operator to work - HELP

Private Sub CommandButton1_Click()
With ActiveSheet
If Not .AutoFilterMode Then .[H2].AutoFilter

Range("H2").Select
Selection.AutoFilter
Selection.AutoFilter Field:=6, Criteria1:=">12/31/2008" AND
Selection.AutoFilter Field:=6, Criteria1:="<=12/31/2009"
Selection.AutoFilter Field:=8, Criteria1:="VRE"

End With

End Sub

 

[SkipVought]

Dates are not strings.

Dates are NUMBERS. You must CONVERT your string to a REAL DATE. faq68-5827

Use the DateValue or DateSerial fucntion.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[grierfield]

Still having trouble - could you show an example? thanks

 

[PHV]

Why not do it manually with the macrorecorder on ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[grierfield]

PVH writes - Why not do it manually with the macrorecorder on ?


Mnnnnnnnn----- how does one record a macro and then get the "AND" operator in there?

 

[SkipVought]

how does one record a macro and then get the "AND" operator in there?

Select an AutoFilter with more than one criteria.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]