Private Sub CommandButton1_Click()
Range("e1:e2").Merge '合并单元格
End Sub
Private Sub CommandButton1_Click()
'定义变量
Dim i As Integer
Dim rng As Range
Application.DisplayAlerts = False
'把选取赋伯给g区域变量
Set rng = Selection
'循环开始: 从下方单元格礼上合川
For i = rng.Count To 1 Step -1
'Vithi语句开始
With rng
'定相邻单儿格如果值样,合并
If .Cells(i).Value = .Cells(i - 1).Value Then
Union(.Cells(i), .Cells(i - 1)).Merge
End If
'With语句结束
End With
'循环结束
Next
'打开系统误醒
Application.DisplayAlerts = True
End Sub