VBA Arrays help required - Copying a cell several times

hi

My situation is as follows. I have a list of 1400 eight digit numbers in column A. I need to copy each number 25 times
and paste the resulting list of 35000 numbers (1400 x 25 ) on a second worksheet.

I tried doing this by looping through each cell but its just too slow.
How can this be done using vba arrays please, for speed purposes. im relatively new to VBA and struggling.

Many thanks.

Please attach a sample.

sample.xlsx

Originally Posted by AB33

Please attach a sample.

Sample now attached. Many thanks

numbers in column A of active worksheet copied x25 to new sheet called "Output"

Please Login or Register  to view this content.

Try the attached.

This is slightly faster.

@AB33 - Thanks so much! works like a charm!

How would i modify this to copy a block of numbers that is 25 rows by 1 column, down a column one after the other?

cheers

The code does 25 rows by 1 column?

Do you mean that you have more than 1 columns?

The making of those row copies was the first step of my task. Your code was perfect.
They they wanted another block of data, consisting of 25 rows by one column (so basically a column of data)
to be copied next to the rows we generated earlier. That is eg Paste it to cover rows 2 to 26, move down to the first empty
cell below what you just pasted and repeat the process. All the way down.

I gave it a go and replaced the code in your for loop with:

Please Login or Register  to view this content.

which worked. Do you have a more elegant scalable solution? cheers