Paste Method of Worksheet Class Failed for simple macro

Hello, I'm attempting to record a macro for a simple sorting of data, to compile it in one column among a few other steps. I have determined by trial and error that it is the compiling to one column step that is giving me an error while my sorting and other functions are working alright. Here is the step that is giving me an error:

(I've provided red text for where the debugger is suggesting, and I've also tried "PasteSpecial" on that line to no success)

Please Login or Register  to view this content.

Not an expert at all, so I'm not sure what can be learned from the above. I'm trying to paste all from the three other columns into one column. The data appears to be there despite the error message coming up.

Thanks for your help!

By the time the code gets to the Paste, there's nothing to paste!

The line

Please Login or Register  to view this content.

clears the Clipboard.

And you will have to do each Copy/Paste in order. You can't copy a number of ranges and then paste - you will only paste the last copied range.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer