Copy range into every 2nd of a pair of blank rows.

Hi again,

I am pretty new to VBA, and encouterd a probelm I can not solve by myself.

Right now I am trying to prgramm a VBA that copies a row (Range e6:U6) to into every 2 blank rows that exist in the a specified range (E7:U300).

To make it more understandable, I have a list that has data from Range E7:U200. I already managed to write a macro that identifies when there is a change in value in Column R (Say I start with 4 cells that have the input “XXXX” Followed by cells that have “YYYY”) and then inserts two blank rows. However, I now want to copy into the second of those blank rows the input that is in Range (E6:U6).

Is there any lean macro that can do that?

Many thanks for your help in advance

J