Selecting dynamic row range in vba

[dshafique]

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 = 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!

 

[dshafique]

thank you very much guys, this is what I needed.

 

[My Aswer Is This]

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.

thank you very much guys, this is what I needed.