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:
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