AutoFilter Method of Range Class Failed

[Cydonija]

Hi There,

I am having an issue with this Macro, basically it will work to a degree but then start to fail for some reason. I have checked some other posts relating to this and have made sure that the AutoFilter is off, and that seems to be along the right tracks but I will start getting the 1004 error.

The code is as follows:-
Sheets("HOLDS").Select
Selection.AutoFilter Field:=11, Criteria1:="Delivered post R3"
Range("I60").Select
End Sub

The text in red is where the Debug points to an issue.
Any help would be great as I am losing the will to live!!!

 

[Andrew Poulsom]

What is Selection on that worksheet? It's best to be explicit about the range you want to AutoFilter.