Generate random numbers in Excel

[Mahesh]

Hi

i am looking to generate random numbers in excel.
Step :
1. Select the Range
2. Input box will ask From Number; To Number
3. when i click on ok it will generate random numbers within selected range if possible they should be unique

reference : http://www.ablebits.com/excel-random-generator-assistant-free-addins/index.php
http://www.ozgrid.com/VBA/RandomNumbers.htm

i will appreciate any help on this

[Excel Fox]

Sub GenerateRandomNumbers()

Dim lngFrom As Long, lngTo As Long
Dim rng As Range

lngFrom = InputBox("Enter from value")
lngTo = InputBox("Enter to value. Should be greater than " & lngFrom)

For Each rng In Selection 'Will error out if selection is not a range
rng.Value = GETRANDBETWEEN(lngFrom, lngTo)
Next rng

End Sub
Function GETRANDBETWEEN(lngFrom As Long, lngTo As Long)

GETRANDBETWEEN = lngFrom + Int(Rnd() * (lngTo - lngFrom + 1))

End Function

[Excel Fox]

You could always use =RANDBETWEEN() in Excel 2007 and greater, in which case you could modify the function to
Function GETRANDBETWEEN(lngFrom As Long, lngTo As Long)

GETRANDBETWEEN = Application.RandBetween(lngFrom, lngTo)

End Function

[Mahesh]

Thank u so much Kris ! :)
Really appreciate your knowledge & help :cheerio: