Easy Copy-Paste Question

**ExcelFinWizzard** · 06-28-2012, 03:50 PM

Hi, I'm wondering if someone can help me create a simple macro that takes one range of cells (i.e. A1:C10) and pastes it (along with formulas, just a normal CTRL+V) down a certain amount of rows (i.e. Paste A1:C10 to A11:C21). Then when I run that macro again, it pastes that same data down the same amount of rows (i.e. Paste2 A11:C21 to A22:C32). Over and over so long as I keep running the macro...

And I understand that I can not simply go back in a macro (if I run the macro too many ties) but that's ok. I can delete the data if I do.

Thanks in advance for the help!

**Steffen Thomsen** · 06-29-2012, 02:49 AM

Hi,

Try this

Sub Steffen()
          uRows = Sheets(1).UsedRange.Rows.Count
          Sheets(1).Range("A" & uRows - 9, "C" & uRows).Copy Destination:=Sheets(1).Range("A" & uRows + 1)
End Sub

This code is based on the assumption that the sheet doesnt hold more rows of data than the part thats getting copied, it can have as many columns as you want.