Change order of columns when pasted?

I have a macro that pulls columns A,C,D,F from sheets"database" and pastes them in A,B,C,D in sheet1 . The problem is, I don't want them pulled and pasted in that order, I want them instead to be in a different order. Is there a way to paste them in a different order?
I just want to swap the last two columns so that it looks like this: database column A goes to sheet1 colum A, database column C goes to sheet1 column B, database column F goes to sheet 1 column C and database column D goes to sheet 1 columnD

Here is the macro, it is also located in the worbook under the "runreport" module. THanks in advance everyone!!

Please Login or Register  to view this content.

Unless you're copying and pasting the columns separately, then I can't see a way to paste in a different order. (Someone else may know better)
However, you could just swap the last two columns around after pasting with something like this.

Please Login or Register  to view this content.

I don't think there is a way to change the order of the columns on the copy & paste instruction, but it should not be difficult to "move" the columns around in the target worksheet after the copy & paste has been performed. Just record the cut & paste steps and add the steps to your macro