Change references where required.
Sub Maybe() Dim arr1, i As Long, a As String arr1 = Range("A1:B" & Cells(Rows.Count, 1).End(xlUp).Row).Value For i = LBound(arr1) To UBound(arr1) If a = "" Then a = arr1(i, 2) Else a = a & ", " & arr1(i, 2) End If Next i Cells(1, 4).Value = a End Sub
Bookmarks