If it's a specific range like that then you may be best using the 'Record Macro' feature under the developer tab. Then just copy and paste it as needed and you will have a code.

Then you can see how it works...

If this unsuitable or the range to copy might change over time then I can give you a code for this...

Strud