Run-time error '1004' ; AutoFilter Method of Range class failed

**ESMAMAF** · 11-18-2012, 07:27 AM

Hello,
I need your help.
I have a macro that has been running daily for several years.
Among the executed instructions, that should do it several times:

Sheets("ENTRADA1").Select
Range("A1").Select
Selection.AutoFilter Field:=1, Criteria1:=AÑOX

In the 5th execution, the compiler stops always at the command Selection.AutoFilter and show the message "Run-time error '1004 '; AutoFilter Method of Range class failed"
After that, I do a reset of the macro:
1. - On the sheet, the arrow has disappeared (Dropdown) and you can enable / disable the autofilter
2. - Restart: fails on first run

Finally, I have no solution to work with the latest backup, regenerating new version.
What is the problem?
Thanks for your help
MAF

**davesexcel** · 11-18-2012, 09:41 AM

Hi and welcome to the forum,
What is AÑOX?

**ESMAMAF** · 11-18-2012, 12:42 PM

Tanks you
I apologize the lack of translation
"AÑOX" is an integer variable which means the current year (=YEAR(now())
Best regards
MAF

**davesexcel** · 11-18-2012, 12:58 PM

I just wanted to make sure it was a variable.

Do you get the error if you set autofiltermode=false before you run autofilter?

with Sheets("ENTRADA1")
.autofiltermode=false
.Range("A1").AutoFilter Field:=1, Criteria1:=AÑOX
end with

**ESMAMAF** · 11-18-2012, 05:54 PM

Thanks for your proposal, davesexcel

I've tried your suggestion; unfortunately, the code stopped again elsewhere
I remember that this macro has worked for many years, every day.
Now, in each execution of the Sub, it must run 25 times for the part of the code showed: fails to 5th.
Now, when failure occurs:
1.-Arrows autofilter disappear, in sheet "ENTRADA1"
2.-In this sheet, the AutoFilter does not work manually
3.- The macro recorder does not work.
I test other changes: Before running this piece of code, I delete, add and move the worksheet "ENTRADA1" to a new workbook. I executed successfully this part of the code. However, the code fails to update a graph
When I recover the last good backup and regenerate a new book, it works fine for 15 days
My conclusion: The book is corrupted after 15 days and it’s not possible regenerate. How I can avoid this corruption?
Best regards
MAF