Copy cells X number of times [ Without Changing the order ]

I need to copy a range of cells to x number of time without changing the order. Please help
Ex : I need to copy data in cells A1:A5 for 100 times without change in order in cells.
Refer A Column in sample file as input and C column as output

Hi,

Your question is not clear enough, more explanation is required. Perhaps you can upload an example of your workbook with the explanation in it like where does the copied range must be copied to, how the order must be set, and so on.

Hi,

Your question is not clear enough, more explanation is required. Perhaps you can upload an example of your workbook with the explanation in it like where does the copied range must be copied to, how the order must be set, and so on.

I attached the sample file, please check and let me know if you can help in this...

Hi,

Here's a sample file with code. Be sure macro's are enabled, otherwise it won't work.

Thanks Davis, made this change... t = InputBox("No of times") and works as expected.