Copy and Paste Range Down X times

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.

Hi all,

I found the solution below. Thank you.

Please Login or Register  to view this content.

Hi

try Below code

Please Login or Register  to view this content.