Apr 18 2022 10:29 AM
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]