VBA Copy and Paste

[rusted314]

I have a range of data from cells A7 to F345. I need to copy and paste it in the same column 75 times. Is there a quick macro to do this so I dont have to keep copying and pastings? For example the data in rows A7 to F345 would copy to rows A346 to F684 , then A685 to F1023 etc...

Thanks
John

 

[Norie]

John

Try this.

Set Rng = Range("A7:F345")
 
Rng.Copy Rng.Offset(Rng.Rows.Count).Resize(Rng.Rows.Count * 75)

 

[rusted314]

Works great!

Thank you