Macro for specific row addition

Copper Contributor

I don't get to use macros very often but when I do I try to overshoot my level of knowledge.  I am trying to use a macro to either add rows with the intent of the new rows to be the exact same as the above active cell row or a copy/insert copied cells solution but I need them to be blank.  I am having a difficult time finding any examples to exactly what I am needing to do.  I am open to suggestions on the best solution.  Any help is greatly appreciated.

 

Example:

[B1/C1/D1 merged], [E1], F1/G1/H1 merged], [I1/J1 merged]

0 Replies