Macro: Copy, Insert, Paste and Clear the Merged Cells from the previous row.

I am trying to write a Macro that will do the following.

From an existing Worksheet not Table

Copy a row with merged columns
Insert the row below it (down)
Paste the row with the formatting in tact (all merged columns stay the same)
Clear the Cells from the previous row.
Return to the “A” column in the new row.

I can’t have the formula include any “constants” because the worksheet will be moving all the time.

Also, if at all possible I would like the macro to work when I hit enter from my merged column j:L

 Can anyone HELP me?

Thank you in advance.

By: Diana Zeunen

Leave a Reply

Your email address will not be published. Required fields are marked *