Unique random numbers between two numbers

Hello everybody
I have this udf function that generates unique random numbers between two numbers

Function UniqueRandBetween(Bottom As Integer, Top As Integer, Amount As Integer) As String
    Dim iArr As Variant
    Dim I As Integer
    Dim R As Integer
    Dim Temp As Integer
    
    Application.Volatile
    ReDim iArr(Bottom To Top)
    
    For I = Bottom To Top
        iArr(I) = I
    Next I
    
    For I = Top To Bottom + 1 Step -1
        R = Int(Rnd() * (I - Bottom + 1)) + Bottom
        Temp = iArr(R)
        iArr(R) = iArr(I)
        iArr(I) = Temp
    Next I
    
    For I = Bottom To Bottom + Amount - 1
        UniqueRandBetween = UniqueRandBetween & " " & iArr(I)
    Next I
    
    UniqueRandBetween = Trim(UniqueRandBetween)
End Function

I need to get the results of this udf in range of cells say ("A1:A10")
For example : I want to generate random numbers between 1 and 30 .. The number of the results should be 7 numbers
So if I used the udf function

=UniqueRandBetween(1,30,7)

I got results in one cell.. I need to get the results in 7 cells

No need to reinvent the wheel, go here: http://www.cpearson.com/excel/randomnumbers.aspx

The function you want is UniqueRandomLongs found about halfway down the page. It appears to have a setup identical to yours, so when you enter that function in a cell as an ARRAY, you will get unique values within that array of cells.

Thanks for reply Mr. JBeaucaire

Is there a way to get the results fron this UDF function in range or it will be difficult and so I will have to search for any other solution?

Your question leads to me believe you haven't really looked at the suggested site. The UDF is designed to provide an ARRAY of results. So if you enter that formula in 10 cells at once using CTRL-SHIFT-ENTER, then that range of cells will be treated like an array and you will get the 10 answers. All the info needed is on that page.

Mr. JBeaucaire
I have navigated the site you provided me and I used the UDF function which was in that page .
It works very well ..
In fact I don't need to solve the problem of getting unique random numbers .. I need to learn how to extract the results of array to be in ranges .. This is my point !
Generally thanks for your help sir

Is it easy to do that task ?

I suppose I do not understand your question at this point.