代码:
Sub 合并()
Application.DisplayAlerts = False
Dim x%
Dim ra As Range
Set ra = Range("a" & 2)
For x = 2 To Range("a65535").End(3).Row
If Range("a" & x) = Range("a" & x + 1) Then
Set ra = Application.Union(ra, Range("a" & x + 1))
Else
ra.Merge
Set ra = Range("a" & x + 1)
End If
Next
Application.DisplayAlerts = True
End Sub