View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default 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