|
用vba凑合一个。
Public Sub 合并单元格() '合并单元格并将合并的单元格设置序号
Dim j, arr(), brr()
Application.DisplayAlerts = False
i = [a65536].End(3).Row
arr = Range("a2:b" & i): n = 0
For j = 1 To UBound(arr) - 1
100
If arr(j, 1) = arr(j + 1, 1) Then
n = n + 1: arr(j, 2) = n: arr(j + 1, 2) = n + 1
Range(Cells(j + 1, 1), Cells(j + 2, 1)).Merge
Else
j = j + 1: n = 0: GoTo 100
End If
Next j
Range("b2:b" & i) = Application.Index(arr, 0, 2)
Application.DisplayAlerts = True
End Sub |
|