No Cells Were Found Error when Macro is Run

[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 goes through the entire macro fine without any errors, yet when I try to run the entire macro, it fails. Any idea why> I am running Excel 2010. I have searched all over the web and forums trying to find an answer to this issue, and I have fouund nothing.

 

[Joe4]

I get an error regardless of whether the code is in the Personal Macro Workbook or the actual Workbook on the first line:

    ActiveSheet.ShowAllData

I think that is because none of the data is hidden/filtered at the beginning. When I replaced the line above with this:

'   If all data is already shown, bypass error
    On Error Resume Next
    ActiveSheet.ShowAllData
    On Error GoTo 0

the code ran without error in both instances.

 

[Jett Midknight]

I don't think that was the problem because the error that line produced was not the No Cells Found Error, at least not in my usage of it. Also when testing it I always made sure that I had some form of filter active. Either way I did find a fix for it. I simply copied the code and created a new macro and it ran fine. I thank you for all of your help though.

 

[Joe4]

There must have been something else going on that we were unaware about, as I did not have that same issue on my end.
While I am curious as to what that might have been, the important thing is that you got it working.
It might have something to do with your environment, which obviously I cannot fully reproduce here.

 

[Jett Midknight]

Perhaps. I thank you again for the time and effort you put into this