Insert blank row in-between range of merged cells

StefanG · May 21st 2021

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,

Stefan

jolivanes · May 21st 2021

Code

Sub Maybe()
Range("B3").EntireRow.Insert
End Sub

StefanG · May 21st 2021

Thank You!

Stefan

Participate now!