Runtime Error 1004 + Runtime 5

Full disclosure, I have posted this code to this website twice before, and both issues were resolved.
I am receiving a Runtime error 1004 and a runtime error 5 when I run my code. I am not sure which lines is throwing the error. Excel presents the warning but does not take me to the line causing the error.

I am looping through a range that was generated by a pivot table, so I know the range items are valid. I am filtering said pivot tables by the range list. From there I am saving the file to a folder that exists.
The odd part is, the code will execute (never completely) with no issue and other times (at various places in the list) it will throw the error.

I have included my code below a sample was too big to attach (no matter what I did to shrink the file size). Any help would be greatly appreciated,

Please Login or Register  to view this content.

I had to strip all the formatting away and delete a few lines, but this is a good representation of what the file is.

Originally Posted by jrean042

... this is a good representation of what the file is ...

No ... because there is no:

1. "Sheet6"

Please Login or Register  to view this content.

2. "Sheet2"

Please Login or Register  to view this content.

in your file.

I'm not sure I can reduce that file down enough to attach. Let me do my best.
I honestly don't think that part of the code is the issue though.

I think its just too big, and there are links to an Access Database, not sure how I would upload a sample file.
Any guidance you can give without seeing the original file would help at this point.

Thank you for your help