Sub test() Dim i% Application.DisplayAlerts = False For i = [a65536].End(3).Row To 2 Step -1 If Cells(i, 1) = Cells(i - 1, 1) Then Range(Cells(i, 2), Cells(i - 1, 2)).Merge End If Next Application.DisplayAlerts = True End Sub
Sub test() Dim i% Application.DisplayAlerts = False For i = [a65536].End(3).Row To 2 Step -1 If Cells(i, 1) = Cells(i - 1, 1) Then Range(Cells(i, 2), Cells(i - 1, 2)).Merge End If Next Application.DisplayAlerts = True End Sub