W
wfzcted
Unregistered / Unconfirmed
GUEST, unregistred user!
Sub ronhy()Dim i&Application.DisplayAlerts = FalseFor i = Sheet1.Range("a65536").End(xlUp).Row To 2 Step -1If Cells(i, 1) = Cells(i + 1, 1) then
Range("a" & i).Resize(2, 1).MergeNext iApplication.DisplayAlerts = TrueEnd Sub
Range("a" & i).Resize(2, 1).MergeNext iApplication.DisplayAlerts = TrueEnd Sub