Hi all,
I'm new to VBA/macros, and I'm having trouble with a pretty simple problem - any help would be appreciated!

I have a row of seven data values in C2:I2 of a worksheet. These values are all results of different formulas that involve the rand() function (i.e. there is a random number input to each formula). I want the values in C2:I2 to be copied & pasted to K2:Q2 in the same worksheet, and then subsequently to K3:Q3, K4:Q4, and so on all the way down to K1001:Q1001 (so there are 1000 iterations). If I start doing this by hand, then each time I copy & paste, rand() generates a new random number so I get a new set of unique values in C2:I2, which is exactly what I want. Using the "record macro" option for the first iteration of this process gives me:

Please Login or Register  to view this content.
My question is, how can I write a macro that will copy & paste C2:I2 to K2:Q2 and then to subsequent rows, with 1000 iterations, ensuring that new random numbers are generated between each copy & paste event?

Thanks so much for your help!
S