An excel selection question

[grierfield]

This is an excel spreadsheet
I want to select data where the “Culture Date” is > 12/31/2008 – this isent quite working


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

Range("H2").Select
Selection.AutoFilter
Selection.AutoFilter Field:= 6, Criteria1 is > "12/31/2008"

End With

End Sub

 

[SkipVought]

Hi,

Please post Excel VBA questions in forum707.

Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]