Hi all,

I am really bad with macro and would like to seek your help.

I need a macro which can copy a range and paste it down X number of times. I have attached an image as an example.

The range will be predefined e.g. ("A2:W8")

Capture.PNG

Thank you so much for your time and help.