Any idea to make code faster

@Winon,

It may speed things up, it may not. It will depend on the workbook.

Also, without knowing the workbook structure, I cannot be sure if turning off calculation would result in the wrong values being pasted somewhere. In fact, it may be the case that the order of copying and pasting affects the results of other columns that are then copied and pasted, in which case my suggestion would not work at all.