17.02.2016, 10:31
@RPP :19:
Vielleicht zum 'testen'
Vielleicht zum 'testen'
Code:
Sub M_snb()
Application.ScreenUpdating = False
sn = Cells(1).CurrentRegion.Columns(1)
With CreateObject("scripting.dictionary")
For j = 1 To UBound(sn)
If .exists(sn(j, 1)) Then sn(j, 1) = ""
x0 = .Item(sn(j, 1))
Next
End With
Cells(1).CurrentRegion.Columns(1) = sn
End Sub