Excel 2010 Not able to run my Macro

Works like a charm. Much appreciated. A few questions in response if you don't mind.

Care to explain why my previous code broke? Was it just a syntax change through the versions as I wondered?

Also, I did add in one line to the If statement within the For.

Application.CutCopyMode = False

We have a large amount of data, and otherwise the user receives a message asking them to clear the clipboard.

Thanks Again!