Need help, Code use to work but now it does not, No error just no data transfered

I have 2 workbooks Active Orders and Completed Orders. The Active Orders Workbook has code to search through the entries and find all the rows with Shipped in Column B. Once it finds them, they are placed in an Array and transferred to the next empty row in the Completed Orders file then deletes the record in the Active Orders WB and inserts new Rows to keep the table with 80 rows. This code was working at one time, I am not the user so I don't know when it stopped working. Now when you push the button it runs through and deletes the rows making the user think that everything had transferred, but when the Completed Orders WB is opened we find that the data was not transferred. I am not sure if it has anything to do with an upgrade in the company to Excel 2016, I know when I wrote the code in Excel 2013 it worked fine. Any help would be greatly appreciated.

Please note the code below has some commented out sections because this file lives in a SharePoint environment and I copied the file to my desktop to try testing and debugging.

Please Login or Register  to view this content.

Ok, so I commented out the Display Alerts, (not sure why I did not notice that originally) and I shortened the code thanks for the help on that. So the code is stalling out at the following line and I don't know why. Any ideas?

Please Login or Register  to view this content.

Ok, I have attached both the Active and Completed Orders workbooks. The Active Orders workbook contains the code. When a date is entered into the Actual Ship Date column the Status column gets set to "Shipped". We press the Transfer Shipped Lines button to search for and transfer everything that has shipped.

Currently the Active Orders file has over 200 lines in it and we have shipped up to 60 lines in a day. So this was very helpful when it was working. The primary users did not tell me when it stopped working.

Thanks bakerman2, I am not sure what happened or why it wasn't working, but like you said it is working fine now. Thanks everyone for the help.