Hi everyone, i've been working on a macro which copies and pastes my table in another sheet 10 rows at a time. I'm trying to make a do while loop and make it dynamic, however, i can't seem to wrap my brain around how to set my range to more than row. for example, this is what I have so far:
I want to select rows i through i+9 (essentially every group of 10 rows
thanks in advance!
Code:
i = 1
k = Range("Q6") 'last row number
Do While i < k
Set Rng = Range("TableAll").Rows(i): Range("TableAll").ListRows (i + 9) ' having trouble with this line
Range("TableAll").Rows(i).Copy
i=i+9
loop
I want to select rows i through i+9 (essentially every group of 10 rows
thanks in advance!
Last edited: