repeat range of data values down through end of table

  • Thread starter Thread starter PiaD
  • Start date Start date
P

PiaD

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
 
Range("B2:")C5.Copy
For RowCount = 6 to 200 step 4
Range("B" & RowCount).Paste
Next RowCount
 
I made a typo

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
Need help with listbox 6
Hide Next row based on Cell Value 3
Count occurances in a range. 5
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
How to add itemfrom a worksheet to a Listbox 2
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
Recorded macro selection widened 4

Back
Top