Excel VBA to Copy Paste Range X Times with the same spreadsheet

[Mike]

I have a spreadsheet that I'm trying to copy and paste the same data range 200+ times down the spreadsheet to the next blank cell, does anyone have any code to automate this. This is a routine process every month. Thanks

EggHeadCafe - Software Developer Portal of Choice
ASP.NET Programmer's Reference [Wrox Press]
http://www.eggheadcafe.com/tutorial...897-012dfdc39b86/aspnet-programmers-refe.aspx

 

[Don Guillett]

More detail with before/after examples or
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
in message news:[email protected]...