Sub wayy() Dim d As Object Dim i As Long Dim Str As String Dim Arr Set d = CreateObject("Scripting.Dictionary") Arr = Range("B1", [b65536].End(xlUp)) For i = UBound(Arr) To 1 Step -1 d(Arr(i, 1)) = Arr(i, 1) Str = Str & Arr(i, 1) If d.Count > 5 Then [c1].Resize(1, 5) = d.items Exit Sub End If Next End Sub
Sub wayy() Dim d As Object Dim i As Long Dim x As Long Dim Str As String Dim Arr Set d = CreateObject("Scripting.Dictionary") Arr = Range("B1", [b65536].End(xlUp)) For i = UBound(Arr) To 1 Step -1 d(Arr(i, 1)) = Arr(i, 1) If d.Count > 5 Then Arr = Application.Transpose(d.items) For x = 1 To 5 Str = Str & Arr(x, 1) Next MsgBox Str Exit Sub End If Next End Sub