hydromodller
07-29-2013, 01:15 AM
Hi all,
I have been battling with what seems like a very simple problem but it has beaten me so far!
I have data in columns in excel (207 rows) in a number of columns. I would like to write a piece of VBA which allows me to copy these 207 rows below the 207 rows above it multiple times, in this case 132 times. So in the end I will have the same 207 rows of data repeated 132 times down a column. If there is a way of varying the number of times it repeats that would also be very useful to me!
I have multiple columns I would to do this to but I guess a simple modification of the code would allow this.
Thanks in advance!
I have been battling with what seems like a very simple problem but it has beaten me so far!
I have data in columns in excel (207 rows) in a number of columns. I would like to write a piece of VBA which allows me to copy these 207 rows below the 207 rows above it multiple times, in this case 132 times. So in the end I will have the same 207 rows of data repeated 132 times down a column. If there is a way of varying the number of times it repeats that would also be very useful to me!
I have multiple columns I would to do this to but I guess a simple modification of the code would allow this.
Thanks in advance!