Macro coming up with debug error,

I included a worksheet i use and the macro's are included in it.

I press ctrl A, B, C, D , E, F , G to complete the file.

For some odd reason i can get through D, but when i press ctrl E it will come up with a debug error. If i save my progress from what D did. Reopen the file and start from E it works. I continue and do F, and G.

As of now i can finish any file but it gets annoying saving the file once i get to d, and reopening it to finish the macro's. Anyone know why it produces an error? but works after saving and reopening it?

Any help would be great , File attached .

Thanks