No Cells Were Found

[Jett Midknight]

So when I go to run a macro, it won't run at all, and I keep getting a "No Cells Were Found" pop up. I'm not sure why, seeing as how this macro worked fine yesterday. I tried stepping through the macro to find where it fails at, and it fails at the first step, which is

    ActiveSheet.ShowAllData
    ActiveSheet.Range("$A$2:$BD$5000").AutoFilter Field:=3, Criteria1:= _
        "Order Filled"

I know some people have used the following fix

[COLOR=#333333]On Error Resume Next[/COLOR]

but when I throw that into my code at the start it doesn't fix the problem. Any help would be greatly appreciated.

 

[Jett Midknight]

So I closed excel and ran the macro again, and now when I step through the macro it runs fine for every step, but I still get the same "No Cells Were Found" error when I try and run the macro from the hotkey.

 

[Jett Midknight]

Still can't seem to find a solution to this