AutoFilter Method of Range Class Failed

Cydonija

New Member
Joined
Nov 9, 2010
Messages
4
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!!! :confused:
 

Some videos you may like

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
What is Selection on that worksheet? It's best to be explicit about the range you want to AutoFilter.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,979
Messages
5,526,024
Members
409,677
Latest member
ssh99

This Week's Hot Topics

Top