How to speed up a copy and paste macro

**Freedom Call** · 05-30-2016, 08:00 AM

Hi all,

I have a macro that copies 4 cells (the input) and pastes into another different 4 cells (these are always the same cells), and because each cell contains a formula, the value is now copied onto another 4 cells (the output). This action needs to be repeated for about 400 (rows) times and at the moment it takes about 30min to run

Therefore, I would like to ask for you help if you know any way to speed it up the macro. I am aware that the "select" action is a waste of time but I cannot come up with any other way to develop the macro.

Please find the code below:

Please Login or Register  to view this content.

Many thanks in advance for you help.

**Mumps1** · 05-30-2016, 08:41 AM

It might be a little easier to help if you could attach a copy of your file with a detailed explanation of what you want to do referring to specific cells.