Sub test()
Dim num As Collection
Set num = New Collection
While x < 12
Randomize
numero = Int(Rnd * 49) + 1
On Error Resume Next
num.Add numero, CStr(numero)
On Error GoTo 0
x = num.Count
Wend
n = 1
For Each cel In Range("B3:E5")
cel.Value = num(n)
n = n + 1
Next cel
End Sub