Copy Range "x" number of times

[GRCArizona]

Hi - I'm having trouble with VBA. I've got a drop down where a user can select 1-10, and this answer will copy a range this # of time. The range to copy is C4:G20.

For example: If a user selects "3", I'd like to copy this range 3 times. The first copy would be pasted into row 23 (IE: C23:G39), and the next copy would paste in row 42 (IE: C42:G58). Is there a way to have the row source be dynamic enough to account for this?

I'm not sure whether to use Select Case or For / Next.

any suggestions would be greatly appreciated.

thx,

gRC

 

[Michael M]

how about this, assuming your dropdown list is in cell "A1"

Sub MM1()
Dim lr As Long
lr = Cells(Rows.Count, "C").End(xlUp).Row
Set x = Range("A1") 'where the dropdown value lives, change to suit
Do Until x = 0
Range("C4:G20").Copy Destination:=Range("C" & lr + 1)
lr = Cells(Rows.Count, "C").End(xlUp).Row
x = x - 1
Loop
End Sub

 

[GRCArizona]

Works perfect! Thanks a bunch Michael M. You saved me a ton of time and file size!

 

[Michael M]

Pleasure....