Using Same Copy Paste VBA in Mac 2011 ver Not Working

I have this macro I've modified multiple times now to get to work in the Mac version of Excel. Each step individually does what it is suppose to do, but when combined it breaks down.

Any help would be much appreciated. Here is the code:

Please Login or Register  to view this content.