Insert blank row in-between range of merged cells

  • Hello,

    Range A1:A6 is merged into 1 range.

    Cells B1, B2, B3, B4, B5, and B6 are not merged. Same for columns C, D, E, and F.

    I can manually select row (header) 3 and insert an entire row. (Range A1:A6 becomes A1:A7.)

    I am unable to replicate this in VBA, with recorded steps or otherwise - it always enters 6 rows instead of 1 single row.

    Old age, lack of gray matter,... what gives?

    Thank you kindly for your guidance,


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!