Excel - repeat range of data values down through end of table

Asked By Pia on 13-Jan-09 03:23 PM
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




Joe replied on 13-Jan-09 05:14 PM
Range("B2:")C5.Copy
For RowCount = 6 to 200 step 4
Range("B" & RowCount).Paste
Next RowCount
Joe replied on 13-Jan-09 05:15 PM
I made a typo

Range("B2:C5").Copy
For RowCount = 6 to 200 step 4
Range("B" & RowCount).Paste
Next RowCount
Pia replied on 13-Jan-09 05:51 PM
Thank you for the response!  I will give it a try.