AutoFilter method failing <p>This sub routine has suddenly stopped working; new sheets have been added, but no change to this code. Any idea why I'm getting the message "Auto filter method of range class failed" Run time error 1004?</p> <pre><code>Sub Hide_Row() Application.ScreenUpdating = False ActiveSheet.Unprotect Range("a6:HO499").AutoFilter Field:=2, Criteria1:="&lt;&gt;" End Sub </code></pre>