Can't fix 1004 Error

A long time ago Nebu created some coding for me. This code has worked for years until now. All of a sudden I'm getting the dreaded Runtime Error 1004 "Application-defined or Object-defined error"

I have tried everything I can think of but the error keeps showing up every time I run the code. Can anyone shed some light on this error from the code below, please.

I'm using Office 365

Please Login or Register  to view this content.

Thanks in advance...
Terry E

I'm not sure. I tried stepping through the code and it does everything until the "Msg Box" line. It paste all the lines pulled form all the sheets. It fails, I guess, right before the date part. I say that because I commented out all the date stuff and the 1004 error was still thrown. Is there some testing that I can do that will narrow down the problem code? I'm not a VBA programmer but I am a geek and can follow code blocks.

It runs through all the statements and pulls all the invoices (what it's supposed to do) but at the very end of the run the error is thrown. The date doesn't change and the "Msg Box" does now display "Task Complete" but I can't figure out what line is causing the problem. This all worked until 2 weeks ago. I run this every Monday and it worked June 3rd an 10th but failed on the 17th.

Terry E

Try qualifying which sheet the last set of Range commands apply to. eg: Sheets("Sheet1").Range(…)

Eureka!

After 6.5 hours of search and implement, I finally figured it out. We had a power outage and when the computer shutdown it left some hidden files behind that were throwing off the code.

First off, thanks for all the help. The problem was another VERY hidden file. Unchecking the "show hidden..." did not show this file, it was "desktop.ini". Once I found it, and I only found it with a 2nd macro file that showed a hidden file ~?CMS displayed. I missed this one in the list because it simply showed up in the "Ds" instead of at the bottom of the list like the ~?CMS file did.

The code is working now and I want to say a big thank you for taking the time to help.

Terry E