Data Filter between two date with in single column

[AT BABU]

Hi all,

Good day for you all.......

I run this code get run-time error "1004" Autofiter method of range class failed

Public Sub MyFilter()
Dim lngStart As Long, lngEnd As Long
lngStart = Range("m1").Value 'assume this is the start date
lngEnd = Range("m2").Value 'assume this is the end date
Range("I1:I1500").AutoFilter Field:=6, _
Criteria1:=">=" & lngStart, _
Operator:=xlAnd, _
Criteria2:="<=" & lngEnd
I Need filter data b/w date cell m1 and m2

 

[pgc01]

Hi

You specified a range with only 1 column for the AutoFilter (I1:I1500) but you use Field=6 which would be the 6th column.
Amend the range.