![]()
Sub SelectUniqueValues() Dim sn, lngRow As Long, lngCol As Long sn = Range("A4:F40") With CreateObject("Scripting.Dictionary") For lngRow = 1 To UBound(sn, 1) For lngCol = 1 To UBound(sn, 2) If sn(lngRow, lngCol) <> "" Then x0 = .Item(sn(lngRow, lngCol)) Next Next Range("K4:K" & .Count + 3) = Application.Transpose(.keys) End With End Sub
Bookmarks