repeat range of data values down through end of table
 

Hi -
I would like to repeat of range/pattern of data values (cells B2 through C5)
down through columns B and C until the end of table....For instance the
values in B2 through C5 would be repeated again starting on next blank row
which would be B6 through C9 and so on...

Thank you!
Pia

repeat range of data values down through end of table
 

Range("B2:")C5.Copy
For RowCount = 6 to 200 step 4
Range("B" & RowCount).Paste
Next RowCount

"PiaD" wrote:

Hi -
I would like to repeat of range/pattern of data values (cells B2 through C5)
down through columns B and C until the end of table....For instance the
values in B2 through C5 would be repeated again starting on next blank row
which would be B6 through C9 and so on...

Thank you!
Pia

repeat range of data values down through end of table
 

I made a typo

Range("B2:C5").Copy
For RowCount = 6 to 200 step 4
Range("B" & RowCount).Paste
Next RowCount


"PiaD" wrote:

Hi -
I would like to repeat of range/pattern of data values (cells B2 through C5)
down through columns B and C until the end of table....For instance the
values in B2 through C5 would be repeated again starting on next blank row
which would be B6 through C9 and so on...

Thank you!
Pia

repeat range of data values down through end of table
 

Thank you for the response! I will give it a try.

"Joel" wrote:

I made a typo

Range("B2:C5").Copy
For RowCount = 6 to 200 step 4
Range("B" & RowCount).Paste
Next RowCount


"PiaD" wrote:

Hi -
I would like to repeat of range/pattern of data values (cells B2 through C5)
down through columns B and C until the end of table....For instance the
values in B2 through C5 would be repeated again starting on next blank row
which would be B6 through C9 and so on...

Thank you!
Pia