亲,貌似没那么复杂: Sub hbdyg()Dim rg As RangeFor Each rg In Range("D2:D" & Range("D" & Rows.Count).End(xlUp).Row) If rg.Offset(0, -1).MergeArea.Address = rg.Offset(-1, -1).MergeArea.Address And rg = rg.Offset(-1, 0).MergeArea...