How to repeat a macro many times

[cbo]

Hi: I have a large data set in which I need to insert four cells in between each value, shifting the cells down each time. I recorded a macro to insert the 4 cells and shift down. Somehow I would like to be able to apply this macro to the entire data set (which is over1500 cells and will end up just under 7000 cells.) Is this possible to do in one or a few steps?
Thanks for your help!

[JBeaucaire]

Many ways. Here's one way with no macros:

1) IN an adjacent cell to you data, put in numbers, 1,2,3, etc. Just put in 1 and 2 in the first two columns, then highlight those two cells and drag the bottom right-corner down the whole data set to get the full set of numbers.

2) Copy the full set of numbers and paste directly below the first set in the blank rows below. Do this 4 times.

3) Now highlight both the number column and the original data column

4) Sort ascending by the number column.

5) Delete the numbers.

[cbo]

Thanks for your help JBeaucaire! That was so incredibly easy!