Error 1004: AutoFilter method of Range class failed

[vaibhavdxt]

I am using same code in three different functions and it's working fine with two of them but with third one it's giving me "Error 1004: AutoFilter method of Range class failed".

I have a long code and I am getting error in this part of the code: -

Code:-

Public Sub XYZ (fcstartdate As Long, finaldate As Long)

With Sheets("XYZ")
.Range("$A$1:$AB$860423").AutoFilter Field:=14, Operator:= _
xlFilterValues, Criteria1:=">=" & fcstartdate, Operator:=xlAnd, Criteria2:="<=" & finaldate

Selection.SpecialCells(xlCellTypeVisible).Select
End With

End Sub

Please tell me what I should do to correct it.

I have checked that sheet is NOT protected and there is no merged rows. I also checked the number of rows in the sheet by recording macro which tells me there are 860423 though I see 67423 rows only.

Also when I ran the code with both figures (860423 and 67423), it gave me the same error.

Thanks in advance.

Regards

 

[vaibhavdxt]

Thanks MARK858.

Yes I understand what Sektor is trying to say and I will change that in my code. But it is unbelievable to me as my code for other two functions runs without any problem. I am using those two functions from two months in my code. Today I added two more function, just by copying the code and changing the names and it is showing me error.

 

[MARK858]

And changing the relevant part of the code to the code I posted gave you what?

But it is unbelievable to me

from the Autofilter method on MSDN...

The criteria (a string; for example, "101"). Use "=" to find blank fields, or use "<>" to find nonblank fields. If this argument is omitted, the criteria is All. If Operator is xlTop10Items, Criteria1 specifies the number of items (for example, "10").