Copy rows/range and paste n number of times based on last used cell in Column A

Hi,

i am trying to create a macro to run following scenario:

I have a working sheet with rows 1 to 10 defined as a range block that needs to be copied n number of times. I have created a input message box asking user to "Enter how many times you would like it copied".

Based on user entry, i would like to copy the range block and paste that block n number of times below the last used cell in column A. I formatted data so that: only starting row of data in a block will be in column A in that way, we can find the last used cell after each insertion easily.

Any help or direction on this will be greatly appreciated.

Thanks,
Kon.

Is it what you need

Please Login or Register  to view this content.

Thanks for the input PCI.

I am close with what i need from your solution. But, i am looking for below specific question as described below with attached as the reference:

In the attached spreadsheet i defined rows 1 to 6 as a named range, say "ABCD". i have data filled out by user upto row 17 and i have cell A18 filled with helper data (which will help to find the last used value in column A). Now, based on user entry of data in input box, i would like to copy range "ABCD", insert number of rows equal to the rows in range "ABCD" just above helper row and paste the copied range into inserted rows. I would like to do similar process number of times specified by the user in input box.

Thanks and appreciate your help in advance.

Kon

Ty next code

Please Login or Register  to view this content.