Sub justtest() Dim k%, dic, i% Set dic = CreateObject("scripting.dictionary") k = 0 Do While k < 10 i = Int(Rnd() * 51) If Not dic.exists(i) Then k = k + 1 dic.Add i, "" End If Loop Cells(3, 2).Resize(10, 1) = Application.Transpose(dic.keys) Set dic = Nothing End Sub
Sub justtest() Dim k%, dic, i% Set dic = CreateObject("scripting.dictionary") k = 0 Do While k < 10 i = Int(Rnd() * 51) If Not dic.exists(i) Then k = k + 1 dic.Add i, "" End If Loop Cells(3, 2).Resize(10, 1) = Application.Transpose(dic.keys) Set dic = Nothing End Sub