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.